Sunday, May 25, 2008

Guide on OCS Database tuning (SQL)

For Midrange (8 GB of memory) and High End (12 GB+ of memory)

>If 32-bit version of SQL Server is running, enable Lock Pages in Memory ( and enable AWE (

>These settings are not necessary if SQL server is 64 bit.

>Add a SQL Server trace flag for T4618 (

1) Open SQL Server Configuration Manager
2) Select SQL Server instance, right-click, and then click Properties.
3) In the Advanced tab, click Startup Parameters.
4) Append ;-T4618 to the end of the Startup Parameters list and click OK.
5) Restart SQL Server.

No comments: