reset server periodically?

I see that the memory of the server is running full after a while. Mostly eaten up by the sql server.

Does someone reset the server periodically to prevent this? Or does it just need more than 8gig memory?

SolidworksSolidworks Pdm enterprise Pdm
Answers 7
SS
SS 2018-04-09 Best Answer

Hi,

Of course, if it is more better, especially if all servers on one host.

But that about the swap file? What size is recommended by System?

https://www.solidworks.com/sw/support/PDMSystemRequirements.html

It isn't really clear that periodically to restart? Archiv Server? SQL Server? PDM Server? Host? (there is also SNL Server).

In Services it is possible to establish restart for any Server at failures and stops if it is necessary.

JD
JD 2018-04-09

I am assuming you are referring specifically to the SQL server.  You may want to reach out to your VAR to have them check out what it is that is causing the memory usage. I think each setup would be unique, but we found the xRef was doing a lot of work, and SW was able to make a small adjustment and drastically improve the memory usage.  Prior to this we did restart the server at times to release memory.

SS
SS 2018-04-10

I'm not a SQL guru, but know enough to get myself out of trouble.

SQL Server is designed to use all the memory on the server by default.

This is so SQL can cache the data in the database in RAM so that it can access the data faster.

I run SQL 2014 on a separate VM server than my SolidWorks PDM archive server.

My db admin created separate SQL instances for PDM and Electrical.

This was we can set a maximum memory allocation per SQL instance, so it will never use up all my server memory.

comment imagecomment image
SL
SL 2018-04-10

SQL server needs lots of memory, it will load the whole database into memory if there is enough of RAM, you need at least 16-32 GB

AG
AG 2018-04-10

It's normal for SQL to sometimes use all available memory. The SQL server memory should be at least 4 GB and should be increased as database size increases to ensure optimal performance. So your 8GB should be enough but more is always better. We use 16GB.

Also check out this solution in the KB:

S-055090 What are some best practices to manage memory to avoid Microsoft® SQL Server process hosting SOLIDWORKS® Enterprise PDM  databases from taking all available operating system memory?

JD
JD 2018-04-10

We are setup the same way.

MM
MM 2018-04-11

You must set the maximum memory option in SQL server Per the previously mentioned S-055090.  SQL by default assumes it lives alone on a dedicated server and uses all memory available to it.  By setting this you leave memory for other running processes and the Operating system.