Updating the isolation level for SQL server databases

If you are using an SQL Server, you must update the isolation level of your release, community, customization, and JCR databases to improve concurrency and efficiency of the databases.

Before you begin

Ensure that the database is not in use.

Procedure

Run the command: ALTER DATABASE database_name SET READ_COMMITTED_SNAPSHOT ON;.