Best practices for the Max Server Memory option in SQL Server

Article:TECH97003  |  Created: 2009-01-23  |  Updated: 2011-06-28  |  Article URL http://www.symantec.com/docs/TECH97003
Article Type
Technical Solution


Subject

Issue



This document describes best practices for the Max Server Memory option in SQL Server.


Solution



For performance reasons, Symantec recommends the minimum value of "max server memory" option of SQL Server to be based on the number of clients Symantec Protection Center manages.

  • For companies with fewer than 100 agents, the "max server memory" value should be at least 64.
  • For companies with between 100 and 500 agents, the "max server memory" value should be at least 512.
  • For companies with greater than 500 agents, the "max server memory" value should be at least 1024.


If the configured value of SQL Server does not meet this requirement, a warning message will appear when you install, upgrade, or configure Symantec Protection Center.

If you need to change the max server memory for SQL Server, follow the instructions provided by Microsoft: http://msdn.microsoft.com/en-us/library/ms178067.aspx.


 


Supplemental Materials

SourceETrack
Value1889309,2233209

Legacy ID



2009102315250848


Article URL http://www.symantec.com/docs/TECH97003


Terms of use for this information are found in Legal Notices