Technical FAQs

Ask a Question

Video: How To Limit SQL Server Memory Usage

SQL Server is using a large amount of RAM memory which is resulting in poor system performance. 
Product Line: 
Struxureware Power Monitoring
Power Monitoring Expert
ION Enterprise
SQL Server 2005, SQL Server 2008 R2, SQL Server 2012
By default, SQL Server will utilize as much RAM memory as possible. 
It is possible to set limits on how much RAM memory SQL is allowed to request from the Operating System. 

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio.*

1. Start SQL Server Management Studio and log in to your SQL Server instance.
2. Right-click the SQL Server name and click Properties in the menu to open the Server Properties dialog.
3. Select Memory in the left pane and adjust the value in the Maximum server memory field.
Note: Continuous Engineering recommends setting this value to 4GB less than the total amount of RAM available. 
4. Click OK to apply the changes and close the dialog.
5. Close SQL Server Management Studio.
Was this helpful?
What can we do to improve the information ?