Release Notes › Install and Upgrade Considerations › Prevent Deadlocks After Upgrading a Microsoft SQL Environment

Prevent Deadlocks After Upgrading a Microsoft SQL Environment

When upgrading from CA GovernanceMinder 12.5 SP7 or an earlier release and using a Microsoft SQL database, if you make many updates at once, deadlock exceptions can occur. To improve performance while making many updates, run the following query on the SQL database while the CA GovernanceMinder server is down:

ALTER DATABASE eurekify_sdb
                SET READ_COMMITTED_SNAPSHOT ON;
GO
ALTER DATABASE eurekify_sdb
                SET ALLOW_SNAPSHOT_ISOLATION ON;
GO

When running the script on an existing database, it can take a very long time. If possible, we recommend the following procedure:

1. Stop the CA GovernanceMinder server.
2. Restart the Microsoft SQL service.
3. Run the query above.
4. Start the CA GovernanceMinder server.

Note: This query is done during installation for CA GovernanceMinder 12.6 and later.