How to Configure SQL Server RAM Limits

How to Configure SQL Server RAM Limits

This article will guide you through setting up RAM limits for Microsoft SQL Server to ensure optimal performance while leaving sufficient resources for the operating system and other applications.


  1. Launch SQL Server Management Studio (SSMS)
    Click Open
  2. Right-click the SQL Server
    Click Properties
  3. Select Memory settings
    Set the following specific Memory Limits
    Minimum server memory in (MB):     4096
    Maximum server memory in (MB): 8192
    Click OK
Verify the memory configuration using the following SQL query:
  1. SELECT 
  2.     [name], 
  3.     [value_in_use]
  4. FROM 
  5.     sys.configurations
  6. WHERE 
  7.     [name] IN ('max server memory (MB)', 'min server memory (MB)')
This query will display the current maximum and minimum memory settings, to confirm that the changes were applied correctly.