EPDM – SQL Memory Settings

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.

 

Become a SolidWorks Expert

If you want to become more efficient with SolidWorks then learn SolidWorks live over the web with Javelin. Classes include Drawings, Surfacing, Sheet Metal, Simulation, plus GD&T.

Comments

  1. says

    It is important to note this is only really applicable when running on a 32bit OS. Otherwise it is not recommended this be messed with and just to increase the amount of RAM. If you are not able to load the database into the free RAM then your server is underpowered. For Enterprise level applications it is not unreasonable to recommend running it on Enterprise grade hardware as well.

  2. Joe says

    Hi Lou,

    I just returned from a workshop at SoilidWorks facilities in Boston. I brought up this topic with one of the EPDM guru’s, and they are recommending this for 64 bit systems.

    Thanks for your comment,

    Joe

  3. Corey Vantilborg says

    I think the confusion here is over the purpose of this change. As Joe’s article indicates this is so that the SQL service will not take all of the available memory in the system. Since there are other services which need to run on a EPDM SQL machine(notably the EPDM DB Service) they need some memory. It has nothing to do with 32/64 bit architecture.

    I have always found it odd that by default the SQL service will leave no free memory for system use, causing the OS to use the page file like crazy if you have one. If you have a server with lots of RAM (100G+) then using a page file doesn’t make much sense, so the default SQL configuration will cause performance issues.

    This set-up needs to be part of the basic SEPDM install instructions.

  4. Joe says

    Hi Corey,

    I’ll forward your idea about having this as part of the basic SEPDM install instructions, to Solidworks.

Leave a Reply

Your email address will not be published. Required fields are marked *