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 (http://r.office.microsoft.com/r/rlidOCS?clid=1033&p1=LockPage) and enable AWE (http://r.office.microsoft.com/r/rlidOCS?clid=1033&p1=AWEon).

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

>Add a SQL Server trace flag for T4618 (http://r.office.microsoft.com/r/rlidOCS?clid=1033&p1=kbT4618)

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.