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

To add a SQL Server trace flag for T4618

  1. Open SQL Server Configuration Manager by pointing to Start, pointing to All Programs, pointing to Microsoft SQL Server 2005, pointing to Configuration Tools, and then clicking 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 Advancedtab.

  4. Click Startup Parameters.

  5. Type ;-T4618at the end of the Startup Parameterslist.

    Note:
    Note that startup parameters are separated by semicolons.
  6. Click OK.

  7. Restart SQL Server.