Set SQL Server Max Memory Setting

Article Content

Overview

When setting the max memory for MS SQL Server we suggest leaving 10% free, or 4GB, whichever is greater
For example, if you have 64GB physical memory, you would set max memory at 58GB to leave 6GB free

Common misconception is to allocate everything to the SQL Server and leave just enough for the O/S but there
are other operations performed by SQL that do not pool from the Max Memory Setting such as Stored Procedures or Profiler.

Note: It is not recommended to remote into a SQL Server that’s tight on memory. If you must or have no other access try
to remember to restart the service or the server if possible to free up resources when you are finished.
Best Practice is to connect with SSMS or SQL CMD even if you are offsite.

Step by Step

Was this helpful?