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:
- Enable Lock Pages in Memory and enable AWE (required if you are
running a 32-bit version of SQL Server). If you are using a 64-bit
version of SQL Server, these settings are not necessary. For
details, see How to: Enable the Lock Pages in Memory Option
(Windows) at
http://go.microsoft.com/fwlink/?LinkId=133033 and awe enabled Option athttp://go.microsoft.com/fwlink/?LinkId=133034 . - Add a SQL Server trace flag for T4618. For details, 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.