How to get dead lock error details in graphical format XDL

As described in one of the previous post How to get dead lock error details in SQL management studio the extended event corresponding to “xml_deadlock_report” will open the file in XML format.

Save this XML format file locally.

Now in SQL management studio, open the above saved file with .xml extension and save it as .XDL extension.

Now in SQL management studio, open the file with .xdl extension.

Viola you will see the deadlock report in graphical format.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s