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 (required if you are running a 32-bit
version of SQL Server). If you are using the 64-bit version of SQL
Server, this setting is not necessary.
- Add a SQL Server trace flag for T4618. For details about issues
that arise without this setting, see Microsoft Knowledge Base
article 927396, "Queries take a longer time to finish running when
the size of the TokenAndPermUserStore cache grows in SQL Server
To add a SQL Server trace flag for T4618
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.
Select the Office Communications Server SQL server instance in SQL Server 2005 Services, right-click the instance, and then click Properties.
Click the Advancedtab.
Click Startup Parameters.
Type ;-T4618at the end of the Startup Parameterslist.
Note: Note that startup parameters are separated by semicolons.
Restart SQL Server.