Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

View Deadlock Graphs

By Wayne Sheffield,

Run this script on the server that is generating deadlock traces. It assumes that the trace file will have the name "Deadlock" somewhere in it's filename.

You can optionally set the file to be loaded.

When you run this script, it will shred the XML deadlock graph, and display information contained within it in a table format.

Total article views: 3443 | Views in the last 30 days: 7
 
Related Articles
FORUM

deadlock

deadlock

FORUM

deadlock

deadlock

FORUM

deadlock

deadlock

FORUM

deadlock

deadlock

FORUM

DeadLock

DeadLock

Tags
deadlocks    
 
Contribute