SQL Server performance monitoring and alerting
Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer
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?
- Posts: 3
- Joined: Tue Nov 13, 2012 10:52 pm
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.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Monitor 3
Who is online
Users browsing this forum: No registered users and 0 guests