Deadlock Graph: TextData xml - interpreting   

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

date: Fri, 19 Jun 2009 15:55:38 -0400   author:   Michael MacGregor

RE: Deadlock Graph: TextData xml - interpreting   

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:

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

date: Thu, 25 Jun 2009 08:15:01 -0700   author:   Jelle