Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > 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: 310 Votes: 2 Revisions: 16

Overview

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.

Environment

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

Steps

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
21:48, 22 Jun 2016

Tags

Classifications

Public