Antoine_Sauteron_1266

MS-SQL Lock Escalation

Discussion created by Antoine_Sauteron_1266 on Oct 28, 2016
Latest reply on Oct 28, 2016 by Peter WIRFS
We need to disable Microsoft lock Escalation on our Automic database.

So we need a detailed list of all tables in Automic Version 10.8 database, where activities are written so that we can give to our db admin to deactivate.

The Automation Engine reads and writes in numerous tables while processing. It's not just about the "activities". Here are some of the most-used :

- all MQ tables : MQCP001, MQCP002, MQWP, MQPWP, MQDWP, etc.
- EH : activities
- AH : statistics
- RH / RT : reports
- OH : objects

However this is only a short list and many other tables are also involved as they are linked with one another. For instance OH is linked to AH, EH, OVPP, OHG, etc.

You may find a complete DB schema here : https://docs.automic.com/documentation/webhelp/english/AWA/11.2/AE//DB%20Schema//db/_structure/HTML/index.htm#ucaaqm.htm


Outcomes