Set the READ_COMMITTED_SNAPSHOT option

About this task

PolicyCenter requires that the READ_COMMITTED_SNAPSHOT option be set to ON. PolicyCenter checks for this condition during application start up.

Important: The use of READ_COMMITTED_SNAPSHOT greatly increases resource requirements on the tempdb database. Set tempdb to grow in 10% increments, and provide sufficient disk space for tempdb to grow substantially. You can improve performance if you dedicate separate I/O resources to tempdb.

Procedure

  1. In SQL Server Management Studio, click New Query.
  2. In the query pane, enter: 
    ALTER DATABASE dbname
SET READ_COMMITTED_SNAPSHOT ON
WITH ROLLBACK IMMEDIATE
GO
  3. Click Execute.
    SQL Server Management Studio shows you that the command completed successfully.