This Knowledge Document refers to DE (dSeries) setup with MS SQL database.
DE sometimes takes long time to start jobs. Jobs get delayed and cause scheduling issues.
Release : 12.x
Component : CA WORKLOAD AUTOMATION DE (DSERIES)
Database: MS SQL Server
Tracelogs show extensive SQL deadlocks.
The deadlocks are regularly observed in MS SQL. They are cleared by SQL server side and DE has no control over them. Unfortunately, this results in performance issues and also in delay of jobs running on time. When deadlocks occur, the DE Server has to wait for the deadlock to clear.
For more details, please consult your DBA. Run SQL profiler and trace the lock flags 1222 and 1204. DBA may also setup clustered index on Primary key and non-clustered index on other columns.