Memory configuration in SQL Server
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 a limitation of 1024 MB (1 GB) of memory. If the resulting value is over 1024 MB (1 GB), use 1024 MB (1 GB) instead. 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 formula: 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 formula: OS memory in MB = (((System memory in MB / 1024) * 64) + 1024) For System memory over 48 GB, use 4096 MB as the value for OS memory in MB. Set the value as the Maximum memory for the SQL Server. Restart the SQL Server...