Nino.Uziel

Identity Governance-MSSQL Deadlocks when importing

Blog Post created by Nino.Uziel Employee on Dec 1, 2015

When using CA RCM with Microsoft SQL, and making many updates at once, deadlock exceptions may be generated. To improve performance while making many updates, run the following query on the SQL database while the CA RCM server is down:

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

Outcomes