Dispatchers Deadlock Issue
We are frequently getting deadlock issues where all the dispatchers gets hanged and nothing executes in the system. The job log, system logs all shows basic information as some thing like "SQL Exception: Transaction (process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
After few mins the logs section shows the information as lock table overflow message.
Even double clicking on the above messages in the logs sections not opens any other window to show detailed info.
Currently we are using IDM 7.2 SP8 Patch on MS SQL DB.
Can any one kindly suggest what is the best way of handling these situations and troubleshooting methods to find the detailed root cause of this type of issues?