Trace flags 1204 and 3605 
Author Message
 Trace flags 1204 and 3605

I am trying to trace the source of some deadlocking issues we're
encountering in one of our applications. I've turned trace flags 1204
and 3605 on (in the startup parameters). By the way, I'm running SQL
Server 200, SP2...

In the good old days, SQL 6.5 and 7.0 used to give you really good
trace information - plain english and pretty detailed. With 2000, I'm
unable to make heads or tails of anything in the trace output.  Here's
a sample:

Deadlock encountered .... Printing deadlock information
2002-12-04 13:04:57.57 spid4    
2002-12-04 13:04:57.57 spid4     Wait-for graph
2002-12-04 13:04:57.57 spid4    
2002-12-04 13:04:57.57 spid4     Node:1
2002-12-04 13:04:57.57 spid4     Granted thread list:
2002-12-04 13:04:57.57 spid4      SPID: 330 ECID: 0 Statement Type:
UPDATE
2002-12-04 13:04:57.57 spid4      SPID: 324 ECID: 0 Statement Type:
UPDATE
2002-12-04 13:04:57.57 spid4      SPID: 323 ECID: 0 Statement Type:
UPDATE
.............

Then this:
2002-12-04 13:04:57.57 spid4     Wait thread list:
2002-12-04 13:04:57.57 spid4      SPID: 122 ECID: 0 Statement Type:
UNKNOWN TOKEN
2002-12-04 13:04:57.57 spid4    
2002-12-04 13:04:57.57 spid4     Node:2
2002-12-04 13:04:57.57 spid4     KEY: 15:1977058079:1 (f502dbbb9e85)
CleanCnt:3 Mode: X Flags: 0x0
2002-12-04 13:04:57.57 spid4      Wait List:
2002-12-04 13:04:57.57 spid4        Owner:0x193bd1c0 Mode: X      
Flg:0x0 Ref:1 Life:02000000 SPID:154 ECID:0
2002-12-04 13:04:57.57 spid4        SPID: 154 ECID: 0 Statement Type:
UPDATE Line #: 1
2002-12-04 13:04:57.57 spid4        Input Buf: Language Event: UPDATE
xl_3035_1000_sql..tbllocktest SET updatelockguid =
'{9E51D7BD-9853-41AD-B3B3-F3F2DD09915E}' WHERE nodeguid =
'{E097B9B7-67C3-4942-BF8F-F3431A30A04A}'
2002-12-04 13:04:57.57 spid4      Requested By:
2002-12-04 13:04:57.57 spid4        ResType:LockOwner Stype:'OR' Mode:
X SPID:330 ECID:0 Ec:(0x1a0a7508) Value:0x193b9660 Cost:(0/0)
2002-12-04 13:04:57.57 spid4    

Is there someplace I can go to find out how to interpret this?

Any help would be appreciated.



Tue, 24 May 2005 00:44:56 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Query Analyzer Server Trace vs SQL Profiler Trace

2. MDAC ODBC Trace Dll Won't Trace

3. Any stored procedures for editing trace output file, while trace is ON?

4. How to setup trace and reading the trace logs?

5. sqltrace broken connection while tracing

6. SQL 6.5 less permissive: is there a TRACE?

7. ALTER DB BKP CTL FILE TO TRACE: how do you retrieve the trace file number in the dictionary ?

8. tracing value of a var in profiler

9. How to put a trace in a stored proc

10. Tracing JDBC Queries ??

11. Tracing Stored Procedures & Feeding Trace File to Index Tuning Wizard


 
Powered by phpBB® Forum Software