Extended Event

Question

Extended Event

ramana3327

SSCoach

Points: 19722
More actions
April 8, 2014 at 6:25 pm

#396563

Hi,
I didn't get chance to work with the extended events.
I am working in the analysis of deadlock. I have extended event log file, which consists of two columns. One is name and another is time stamp. I didn't find any another columns. When I click on one row, it is showing some details like client application, client host name, database name, destination, user name, query_hash,plan_handle, server name, session id, severity, state, user_defined, Sql_text like that.
I am not use how to start analyzing that extended event.
I saw one row showing that XML deadlock report. When I click that, it is giving .XML report in another window.
If any one work on this extended events, please let me know how to start analyze this.
Thanks,
Ramana

Viewing 6 posts - 1 through 5 (of 5 total)

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

If you're looking at the Data Explorer and the event you're looking at is database_xml_deadlock_report, it's going to just have an XML output. You can open that as you've seen and look through the XML to interpret the deadlock. But, if you're looking for the graphical deadlock graph, just save that XML as an .XDL file. You can then reopen it as a graphical deadlock graph. If you capture the event. If you capture the xml_deadlock_report event you should see the XML, but also a second tab that says Deadlock down in the details tab. Clicking on that will show the graphical deadlock graph.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

ramana3327 SSCoach Points: 19722 More actions · Answer 2

Hi Grant,

Thanks for the reply.

When I click the deadlock tab next to the details tab. It is giving graph but I couldn't able understand what that is. Please let me know some more detailed. I am attaching that deadlock graph here.

Thanks,

Ramana

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

See if this tutorial is of any help in understanding the deadlock graph.

The image you pasted is not easy to read.

http://sqlmag.com/database-performance-tuning/gathering-deadlock-information-deadlock-graph

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

ramana3327 SSCoach Points: 19722 More actions · Answer 4

Hi,

This is from the profiler trace but I want to find from extended event. Please share with me the links if have any.

Thanks,

Ramana

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

whether from profiler or from XE, interpreting a deadlock graph seemed to be the question. That link should help in interpreting a deadlock graph.

Here is a link about extracting the deadlock graph from XE

http://blogs.technet.com/b/sqlpfeil/archive/2013/05/27/did-you-know-dead-locks-can-be-track-from-the-system-health-in-sql-2012.aspx

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