Retrieve all deadlock text

BrianHBrianH Posts: 5 Bronze 1
edited November 15, 2012 11:30AM in SQL Monitor Previous Versions
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
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
Sign In or Register to comment.