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.


    • Related Articles

    • Installing Microsoft SQL Server

      This article will walk you through installing and configuring SQL Server for a migration workstation. Visit https://www.microsoft.com/en-us/sql-server/sql-server-downloads and scroll down just a bit until you see Developer and click the Download now ...

    • Installing SQL Server Management Studio (SSMS)

      This article will walk you through installing and configuring SQL Server Management Studio (SSMS). If you have not already installed SQL Server, you should do so prior to installing SSMS. Visit ...

    • How to Enable Remote Connections to SQL

      This guide will walk you through enabling remote connections to SQL Server, allowing other devices on your network to connect to the database. Open SQL Server Configuration Manager Go to Start and search for SQL Server 2022 Configuration Manager ...

    • Install MySQL Community Server

      This article will walk you through the installation of MySQL Community Server Go to this link and download MySQL Community Server MySQL :: MySQL Community Downloads Find the version Windows (x86, 64-bit), MSI Installer Click Download Do not sign in ...

    • Configure PgAdmin 4

      Configure PgAdmin 4 In order to backup and restore databases using PgAdmin 4 you must ensure the Binary Path setting points to where several critical DLLs are saved on your hard drive. Below is the path that is typically correct, but it may vary for ...