search cancel

How to Reduce Occurrence of Deadlocks on our System.

book

Article ID: 89917

calendar_today

Updated On:

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.