To set the memory of MS SQL Server, use the following formula.The default is unlimited in the SQL server during installation.
2GB-Base memory requirement for Enterprise version + (Total Server memory / 2)
*Example 2GB + (16 / 2) = 10 GB.
This is to prevent other services and process such as backup, antivirus and OS operations from reaching a memory limit when the SQL server attempts to use the maximum memory for optimal performance.
Thank you.
More information at this link.
http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.100).aspx
2GB-Base memory requirement for Enterprise version + (Total Server memory / 2)
*Example 2GB + (16 / 2) = 10 GB.
This is to prevent other services and process such as backup, antivirus and OS operations from reaching a memory limit when the SQL server attempts to use the maximum memory for optimal performance.
Thank you.
More information at this link.
http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.100).aspx
