SQL Server Standard Uses all Available Memory
Issue
When using SQL Server Standard, SQL Server uses all or most of the available memory on the server.
Cause
In order to run databases as fast as possible, SQL Server caches as much of the database and queries into memory as possible.
Resolution
SQL Server does this by design in order to increase performance. While this should not cause any problems, if you would like to limit the amount of RAM that SQL Server can use on your dedicated server, please follow the steps below:
- Log into your server through Remote Desktop.
- Open up SQL Server Management Studio and log in.
- In Management Studio, right-click on the server and select Properties
- Click on the Memory section on the left-hand side.
- Specify the maximum amount of memory that you want SQL Server to use. (1GB = 1024MB). 6)
- Click OK
- In Management Studio, Right-Click on the server and select Restart.
Article ID: 501, Created: April 10, 2012 at 7:07 AM, Modified: August 26, 2014 at 9:17 AM