Step 4: Configure SQL Server for Office Communications Server

Step 4: Configure SQL Server for Of...

Microsoft Office Communications Server 2007

After you have created your pool and configured it, you must configure the computer hosting your back-end database to avoid performance degradation.

Configuring SQL for Small Back-End Database (4 GB of Memory)

Use the following procedures to configure on the back-end database server in deployments where the back-end database includes 4 GB memory.

Set /3GB in the boot.ini if you are running a 32-bit version of SQL Server. This setting is not necessary if you are using the 64-bit version of SQL Server.
Add a SQL Server trace flag for T4618 (See the following Microsoft Knowledge Base article for more information about issues that arise without this setting: http://r.office.microsoft.com/r/rlidOCS?clid=1033&p1=kbT4618).

To add a SQL Server trace flag for T4618

Open SQL Server Configuration Manager: Point to Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
Select the Office Communications Server SQL server instance in SQL Server 2005 Services, right-click the instance, and then click Properties.
Click the Advanced tab.
Click Startup Parameters.
Append ;-T4618 to the end of the Startup Parameters list (note that startup parameters are separated by semicolons).
Click OK.
Restart SQL Server.

Configuring SQL for Midrange (8 GB of memory) and High End (12 GB+ of memory) Database Computers

If you are deploying a large back-end database for an Enterprise pool, you need to configure SQL settings to avoid performance degradation:

If you are running a 32-bit version of SQL Server, 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 you are using a 64-bit version of SQL Server.
Add a SQL Server trace flag for T4618 (http://r.office.microsoft.com/r/rlidOCS?clid=1033&p1=kbT4618).

To add a SQL Server trace flag for T4618

Open SQL Server Configuration Manager: Point to Start, point to All Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
Select the Office Communications Server SQL Server instance in SQL Server 2005 Services, right-click the instance, and then click Properties.
Click the Advanced tab.
Click Startup Parameters.
Append ;-T4618 to the end of the Startup Parameters list (note that startup parameters are separated by semicolons).
Click OK.
Restart SQL Server.