4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

Other installation tasks

Adjust the Maximum Memory setting for SQL Server

HP recommends that you reserve approximately 15% of the system resources for the

operating system and Matrix Server. For each SQL instance installed, you should

change the Maximum Memory default setting for SQL Server from “all” to 85% (or

less) of the total physical RAM on the system.

The following script is a template to set the maximum RAM for a particular SQL

instance. If multiple instances are installed on the node, you can divide 85% by the

number of instances. The exact memory allocation should be studied and defined

for your particular environment—some instances may require more memory than

others.

--Set physical memory limit

exec sp_configure 'show advanced options',1

reconfigure with override

declare @percent int, @mem int

HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 41