On-Box SQL Server maximum memory settings for Symantec Management Platform 7.0
Last Updated February 08, 2011
Question How can I improve the performance of Symantec Management Platform 7.0 when SQL Server is on the same computer as Notification Server?
Answer If the SQL Server is on the same computer as Notification Server, we recommend that you optimize your SQL Server maximum memory settings. This can significantly improve product performance. We recommend the following maximum memory settings:
On-Box SQL Max Memory Setting
.9 GB or 1.9 GB when you use the /3G switch
5.5 GB (Use the 3GB/PAE/AWE settings.)
12 GB (Use the 3GB/PAE/AWE settings. The 3GB switch is optional.)
Always test how the memory settings work in your own environment.
These memory settings allow the Symantec Management Platform sufficient memory to function without getting into heavy memory pressure situations with excessive swap file utilization. These settings only apply to a computer with a 32-bit operating system.
You can access the memory settings in Microsoft SQL Server Management Studio. In Object Explorer, on the server's right-click menu, click Properties and on the Server Properties dialog box, select the Memory page. If you use SQL Server Express, you can use SQL Server Management Studio Express to modify the memory settings. SQL Server Management Studio Express can be downloaded for free from Microsoft.
For more details on SQL memory settings, see KB 3977.
For more information, also see Microsoft KB 321363 and KB 319942.
Because the root problem is the amount of memory swapping that takes place, running other applications on the same computer can also contribute to performance issues.
Imported Document ID: HOWTO9654
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe