EPDM – SQL Memory Settings

Article by Joe Medeiros, CSWE, last updated on May 17, 2016

The SQL server will use up memory based on available system resources. Once the memory is allocated it may not be released until the service is restarted. This is normal behavior for SQL and is not a memory leak. The maximum memory used can be controlled through SQL management studio. Generally this option does not need to changed, unless memory usage is proving to be an issue for other applications running on the server.

Start SQL management studio and log-in
Right click on the server and choose Properties.

server properties

 

Select the Memory tab and enter the maximum value.

set memory

 

A general rule is set the maximum server memory to total physical RAM minus 2 GB for the operating system and other applications. Please refer to Solidworks Knowledgebase article S-055090 for more details. The knowledegebase is available to all subscription customers, by logging into the Solidworks Customer Portal.

 

Related Posts

Joe Medeiros, CSWE

Joe Medeiros is a SOLIDWORKS and PDM Certified Expert. He has been helping SOLIDWORKS users with training, mentoring and implementations since 1998. He combines industry experience with a thorough understanding of SOLIDWORKS products to assist customers in being successful. He shares his experience and expertise through blogs; one of which has been incorporated into the SOLIDWORKS Essentials training manual.

Want to learn SOLIDWORKS?

Take a training course from our team of Certified SOLIDWORKS Experts