|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
how to read a 1204 and 1206 trace log entryresponsible 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 Hi Jason
Have you tried sp_blocker_pss80 http://support.microsoft.com/kb/271509/EN-US/ John Show quote "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 > > |
|||||||||||||||||||||||