Click to Rate and Give Feedback
TechNet
TechNet Library
Office
Deployment
 Step 4: Configure SQL Server for Of...
Collapse All/Expand All Collapse All
Microsoft Office Communications Server 2007
Step 4: Configure SQL Server for Office Communications Server

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

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).
  1. 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.

  2. Select the Office Communications Server SQL server instance in SQL Server 2005 Services, right-click the instance, and then click Properties.

  3. Click the Advanced tab.

  4. Click Startup Parameters.

  5. Append ;-T4618 to the end of the Startup Parameters list (note that startup parameters are separated by semicolons).

  6. Click OK.

  7. Restart SQL Server.

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

  1. 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.

  2. Select the Office Communications Server SQL Server instance in SQL Server 2005 Services, right-click the instance, and then click Properties.

  3. Click the Advanced tab.

  4. Click Startup Parameters.

  5. Append ;-T4618 to the end of the Startup Parameters list (note that startup parameters are separated by semicolons).

  6. Click OK.

  7. Restart SQL Server.

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker