Deadlock Graph: TextData xml - interpreting

#1

So I used Profiler to obtain the Deadlock Graph and saved the trace both to
an xml file and to a table. Rather than having to slog thru all this
information, there are over 700 rows, is there a way to extract useful
information either from the xml file or from the TextData column in the
saved table?

TIA

Michael MacGregor
Database Architect

#2

Hi Michael,

You can do a Google Search on "SQL Server Trace Analyzing".

This will give you links to good articles as well as some tools (some free,
some not).

I hope this is helpful.

Regards,

Jelle

"Michael MacGregor" wrote:

Quote:

So I used Profiler to obtain the Deadlock Graph and saved the trace both to
an xml file and to a table. Rather than having to slog thru all this
information, there are over 700 rows, is there a way to extract useful
information either from the xml file or from the TextData column in the
saved table?

TIA

Michael MacGregor
Database Architect

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Deadlock Graph: TextData xml - interpreting

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Deadlock Graph: TextData xml - interpreting - 06-19-2009 , 02:55 PM

RE: Deadlock Graph: TextData xml - interpreting - 06-25-2009 , 10:15 AM