How to Reduce Occurrence of Deadlocks on our System.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to Reduce Occurrence of Deadlocks on our System.

Environment

Release: AUTWAB99000-10.0-Automic Workload Automation-Base Edition
Component:

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.