Skip to main content
InSource Solutions

TN WW182 How to clamp the maximum amount of memory for use by SQL Server

InSource_Logo_Transparent.png

Description

 

This article from InSource shows how to clamp the SQL Server maximum memory.

  • Author: Joseph Hefner
  • Published: 5/18/2017
  • Applies to: SQL Server 2005 and above

Details

Step 1)

Launch Microsoft SQL Server Management Studio:

Capture1.JPG

 

Step 2)

Click the "Connect" button:

Capture2.JPG

 

Step 3)

Right click on the SQL Server instance and select "Properties":

Capture3.JPG

 

 

Step 4)

Set the Maximum Server memory and click the "OK" button.  For System Platform, Wonderware recommends you clamp the memory at 65 % of the computers total memory.

Capture4.JPG

 

Step 5)

If no SQL database connections are currently active, you can restart SQL Server by right clicking the instance and choosing "Restart". Otherwise, it would be better to restart the machine in order to make sure everything is restarted properly.

 

Capture5.JPG