You can create a domain configuration repository on a Microsoft SQL Server database. Configure the database settings based on requirements specific to the domain configuration repository.
Use the following guidelines when you set up the repository on a Microsoft SQL Server database:
Set the allow snapshot isolation and read committed isolation level to ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to minimize locking contention.
To set the isolation level for the database, run the following commands:
ALTER DATABASE
DatabaseName
SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE
DatabaseName
SET READ_COMMITTED_SNAPSHOT ON
To verify that the isolation level for the database is correct, run the following commands:
SELECT snapshot_isolation_state FROM sys.databases WHERE name=[DatabaseName]
SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name =
DatabaseName
Grant the CONNECT, CREATE TABLE, and CREATE VIEW privileges to the database user account.
Specify the schema name when you configure the database for the repository.
ASK INFAPreview
