How to Reduce Occurrence of Deadlocks on our System.

Document ID : KB000089917
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
How to Reduce Occurrence of Deadlocks on our System.
Resolution:

Symptoms

Symptoms

User Interface is very slow with DWP work processes with a very high %,  AE running on MS SQL server.

In the log files, you can see some DEADLOCKS


Cause

"VERSIONING" mode of DB is not enabled


Resolution

Check if versioning mode is turned on or off 

From the Automic database perform the following statement

---------------------------------------- 

SELECT is_read_committed_snapshot_on

FROM sys.databases WHERE name= 'your database name'

---------------------------------------

if the value " is_read_committed_snapshot_on" = 0 the Versioning is off

Then you should ask your DBA to turn it on, it will help to reduce the occurrence of deadlocks.