How To: Set database cache limit on SQL Server

Relates to versions - SQL Server 2005 (9.0.1399.06)+ 

This guide has been created to assist Database and IT Administrators in limiting the amount of memory Microsoft SQL allocates to database caching.

Overview:

By default, Microsoft SQL server will allocate memory for database caching dynamically. The cache settings can be adjusted in the event that SQL Server wants to utilize all available memory.

Steps:

1. Open SQL Server Management Studio and connect to the instance relevant to the server you want to manage the memory allocation.
2. In Object Explorer, right-click the server instance.
3. Select 'Properties'.
   
   
   
   
4. Click the Memory node.
5. Modify the 'Maximum Server Memory (in MB). Set the value depending on the application or requirement advised by your Micromine Pitram Support Specialist.
6. Press OK to submit the change. The change will be effective immediately and additional memory consumed by SQL for caching purposes will be released to the system.
   
   

Want to learn more?

Click here to login to our Learning Management System

Click here to request access