Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Calculate the maximum memory setting for SQL Server

Calculate the maximum memory setting for SQL Server

Table of contents
Created by Magdalena.Markova, last modified by MindTouch on Jun 23, 2016

Views: 8,349 Votes: 2 Revisions: 16


When you experience low performance of the MS SQL Server, or when bad SQL memory settings were discovered during the pre-flight check of the upgrade, you can adjust the maximum memory settings for your SQL Server. 

If you are not familiar with MS SQL Server, ask your SQL Server Administrator to complete the configuration steps. When you are using more than one SQL Server instance, don't use these steps. SolarWinds recommends that you recalculate the SQL Server memory yourself.


  • All versions of NPM
  • MS SQL Server 2008 and later


Tip: If you do not want to calculate the precise maximum memory value, consider using the default value 2147483647 MB which is automatically configured by the SQL Server.


The calculation depends on the edition and version of your MS SQL Server.

  1. Review the edition of your SQL Server.

    MS SQL Server Express
    If you are running MS SQL Server Express, calculate the maximum memory as follows:

    SQL Server maximum memory = System memory in MB – 512 MB

    SQL Server Express edition has limitation to 1024 MB (1 GB) memory. If the resulting value is over 1024 MB (1 GB), use 1024 MB (1 GB).
  2. Review the version of your MS SQL Server.

    32-bit versions of MS SQL Server
    For 32-bit versions, use the same calculation as for MS SQL Express:

    SQL Server maximum memory = System memory in MB – 512 MB

    64-bit version of MS SQL Server

    Calculate the memory setting in the following way:

    SQL Server maximum memory = System memory in MB – OS memory in MB

    OS memory depends on the System memory. To calculate OS memory,  use the following equation:

                   OS memory in MB = (((System memory in MB/1024)*64)+1024)

    For System memory over 48 GB, use 4096 MB as the value for for OS memory in MB.

  3. Set the value as the maximum memory for the SQL Server.
  4. Restart the SQL server to apply your changes. 


You should experience better performance of your SQL Server and the pre-flight check should no longer return the issue.


Last modified



Internal Use Only