Configuring SQL Server for Mid-Range (8 GB) and High-End (12+ GB) Database Computers
Topic Last Modified: 2009-07-20
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 https://go.microsoft.com/fwlink/?LinkId=133033 and awe enabled Option at https://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 https://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 Advanced tab.
Click Startup Parameters.
Type ;-T4618 at the end of the Startup Parameters list.
Note
Note that startup parameters are separated by semicolons.
Click OK.
Restart SQL Server.