Hide this message
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.
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.
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.
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.
You should experience better performance of your SQL Server and the pre-flight check should no longer return the issue.