How can we help you today? How can we help you today?

Retrieve all deadlock text

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
0

Comments

1 comment

Sort by
  • Brian Donahue
    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
    0

Add comment

Please sign in to leave a comment.