Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

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: 7,426 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