"VERSIONING" mode

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

"VERSIONING" mode

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Symptoms

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

In the log files, you can see some DEADLOCK 

---

Cause

"VERSIONING" mode of DB is not enable 

---

Resolution

To check if versionning mode is turn on or off 

From the UC4's database perform 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.