"VERSIONING" mode

Document ID : KB000090520
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
"VERSIONING" mode
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.