SQL Server Standard Uses All Available Memory

Plesk Servers > SQL > MSSQL
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:
  1. Log into your server through Remote Desktop.
  2. Open up SQL Server Management Studio and log in.
  3. In Management Studio, right-click on the server and select Properties
  4. Click on the Memory section on the left-hand side.
  5. Specify the maximum amount of memory that you want SQL Server to use.  (1GB = 1024MB). 6) 
  6. Click OK
  7. In Management Studio, Right-Click on the server and select Restart
 

Add Feedback