how to read a 1204 and 1206 trace log entry

so i'm investigating deadlocks which occur on the database i am
responsible for. i've put in place a 1204 and 1206 trace, and now i'm
just curious how to interpret the findings. i have read the BOL section
on troubleshooting deadlocks, which list the entries for the 1204
trace, but they don't seem to map very well to what i'm seeing in the
actual log file. a few fields map, but several others are missing or
extra. so i have two preliminary questions:
(1) is it safe to post 1204 and 1206 log entries to usenet? i don't see
any data that looks at all sensitive or secure in the log entries, but
just thought i'd make sure.
(2) is this an appropriate group to post a sample log entry to ask how
it should be read? this is where i began the investigation, so it
seemed appropriate to continue it here.
thanks,
jasonHi Jason
Have you tried sp_blocker_pss80
http://support.microsoft.com/kb/271509/EN-US/
John
"jason" wrote:

> so i'm investigating deadlocks which occur on the database i am
> responsible for. i've put in place a 1204 and 1206 trace, and now i'm
> just curious how to interpret the findings. i have read the BOL section
> on troubleshooting deadlocks, which list the entries for the 1204
> trace, but they don't seem to map very well to what i'm seeing in the
> actual log file. a few fields map, but several others are missing or
> extra. so i have two preliminary questions:
> (1) is it safe to post 1204 and 1206 log entries to usenet? i don't see
> any data that looks at all sensitive or secure in the log entries, but
> just thought i'd make sure.
> (2) is this an appropriate group to post a sample log entry to ask how
> it should be read? this is where i began the investigation, so it
> seemed appropriate to continue it here.
> thanks,
> jason
>|||Thanks John, this looks like it could be very useful. I will read up on
it and give it a shot.
Jason