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
2005," at
http://go.microsoft.com/fwlink/?LinkID=126940 .
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. -
Click OK.
-
Restart SQL Server.