SQLMI captured XE for deadlocks does not render load deadlockgraph in SSMS !

Johan Bijnens

SSC Guru

Points: 135470
More actions
October 20, 2022 at 1:14 pm

#4101966
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">
  <data name="xml_report">
    <type name="xml" package="package0" />
    <value>
      <deadlock>
...
      </deadlock>
    </value>
  </data>
</event>
```
Once I remove these elements and keep only
```
<deadlock>
...
</deadlock>
```
SSMS (as wel as SentryOne PlanExplorer) renders it all fine.
Bug or Feature ?

Johan

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
Site Owners

SSC Guru

Points: 80342
More actions
October 21, 2022 at 2:10 pm

#4102527

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)

You must be logged in to reply to this topic. Login to reply