Resolving MSSQL Deadlocks During Bulk Imports - Identity Governance

Products

• CA Identity Governance
• CA Identity Suite

Issue/Introduction

During bulk import operations in the Identity Governance portal, Microsoft SQL database deadlocks may occur due to high-volume concurrent updates.

This article outlines the necessary database configuration changes to resolve these exceptions and improve performance.

Environment

Identity Governance 14.x

Cause

High-concurrency database updates during the import process create contention within the Microsoft SQL environment, resulting in deadlock exceptions.

Resolution

To improve performance and prevent deadlock exceptions, enable snapshot isolation on your database by executing the following queries while the CA RCM server is offline:

1. ALTER DATABASE eurekify_sdb SET READ_COMMITTED_SNAPSHOT ON;
2. GO
   1. ALTER DATABASE eurekify_sdb SET ALLOW_SNAPSHOT_ISOLATION ON;
3. GO

Additional Information

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.