Retrieve all deadlock text

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Retrieve all deadlock text

Postby BrianH » Tue Nov 13, 2012 10:54 pm

I would like to extract from the Redgate database all of the processes associated with deadlock alerts, victim or otherwise. In other words, the GUI displays the SQL statements involved in a deadlock and which was chosen as the victim - I would like to extract those SQL statements programatically. Is that possible?

Thanks,

Brian
BrianH
 
Posts: 3
Joined: Tue Nov 13, 2012 10:52 pm

Postby Brian Donahue » Thu Nov 15, 2012 5:30 pm

Hello Brian,

We do not provide support for querying the SQL Monitor repository database correctly; the unfortunate fact is that we have not been provided with any documentation for the schema.

From what I've seen, deadlock data is kept in the SQL Server error log, and that corresponds to the data.cluster_sqlServer_Error_Instances table.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests