On our Azure Managed Instance we capture deadlock information using an extended events.
No I extraced a single deadlock graph and stored it in a .XDL file, so it can be opened by SSMS and rendered into a graphic.
The reason for this is that the XE stores such data starting with
<event name="xml_deadlock_report" package="sqlserver" timestamp="2022-10-20T12:37:59.739Z">
<type name="xml" package="package0" />
Once I remove these elements and keep only
SSMS (as wel as SentryOne PlanExplorer) renders it all fine.
Bug or Feature ?
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)