September 29, 2014 at 10:35 pm
I know part of it is that I am tired and ready to go get some sleep, but I also believe in NOT recreating the wheel if possible.
Does anyone have an XSL file that prettifies the deadlock graph returned by the Extended Events? If so, would it be possible to get it?
September 29, 2014 at 10:45 pm
Not an XSL, but it is better than that.
Here is a deadlock shredder by Wayne Sheffield.
http://blog.waynesheffield.com/wayne/code-library/deadlocks/shred-deadlock-graph/
You can take the xml from the graph that is produced by XE and just pass it as a parameter if you like.
You can also retrieve it directly from the XE session.
This shredder is highly efficient and will shred those nasty multi-victim deadlocks.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 29, 2014 at 11:10 pm
SQLRNNR (9/29/2014)
Not an XSL, but it is better than that.Here is a deadlock shredder by Wayne Sheffield.
http://blog.waynesheffield.com/wayne/code-library/deadlocks/shred-deadlock-graph/
You can take the xml from the graph that is produced by XE and just pass it as a parameter if you like.
You can also retrieve it directly from the XE session.
This shredder is highly efficient and will shred those nasty multi-victim deadlocks.
Thanks. I will look at when I come back on shift tonight. Right now I need to go get some sleep.
September 30, 2014 at 1:37 pm
Well, it works great, now I just need to figure out what it is telling me.
I am curious about part of it. The QueryStatement column is blank in all the rows, but there appears to be a sqlhandle in the XML data. XML isn't my strong suit, any way to add the extraction of the handle?
September 30, 2014 at 1:48 pm
I'll ping Wayne and have him respond.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 30, 2014 at 1:54 pm
Lynn Pettis (9/30/2014)
Well, it works great, now I just need to figure out what it is telling me.I am curious about part of it. The QueryStatement column is blank in all the rows, but there appears to be a sqlhandle in the XML data. XML isn't my strong suit, any way to add the extraction of the handle?
Lynn - any chance that you can email me the deadlock graph so that I can look at it? I wouldn't post it... too much info hidden in there, and I know where you work...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply