SQL Server Standard Uses All Available Memory
SQL Server Standard Uses all Available Memory
When using SQL Server Standard, SQL Server uses all or most of the available memory on the server.
In order to run databases as fast as possible, SQL Server caches as much of the database and queries into memory as possible.
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.
SQL Server Management Studio
and log in.
In Management Studio, right-click on the server and select
Click on the
section on the left-hand side.
Specify the maximum amount of memory that you want SQL Server to use. (1GB = 1024MB). 6)
In Management Studio, Right-Click on the server and select
Article ID: 501
Created: April 10, 2012 at 7:07 AM
Modified: August 26, 2014 at 9:17 AM
Was this article helpful?
Thanks for your feedback...
Share this article
Send Reset Email
Please log in below
Not Logged In
You must be logged in to perform this action.