Where is the Deadlock Information held

IainFerrie

I am currently using SQL monitor 11 and am try to retrieve deadlock alert details from the redgate database to generate a report that will show the information, I have been able to to identify the deadlock alerts but not the alert details. Please can you advise where the alert details and deadlock process are held within the Redgate database.

Ben_P

Hi Iain,

Thank you for your post.

This link to the SQL Monitor documentation should answer your questions regarding deadlocks:

https://documentation.red-gate.com/sm/overview-and-licensing/investigating-common-sql-server-problems-using-sql-monitor/diagnosing-deadlocks 

Ben_P

Hi Lain, 

Adding to my last comment we unfortunately do not support querying the repository.