Help Me Read Data Collected From Trace Flag 1204

Question

Post reply

Help Me Read Data Collected From Trace Flag 1204

chinn

SSCrazy

Points: 2840
More actions
September 8, 2006 at 8:20 am

#174150

Here is the data i got...from trace flag 1204..Could you guys help me read this..like understand which is the problem child and which one is chosen as a victim any thing that helps me to understand this..


Deadlock encountered .... Printing deadlock information
2006-09-07 03:05:18.92 spid4
2006-09-07 03:05:18.92 spid4     Wait-for graph
2006-09-07 03:05:18.92 spid4
2006-09-07 03:05:18.92 spid4     Node:1
2006-09-07 03:05:18.92 spid4     PAG: 9:1:5151886               CleanCnt:3 Mode: IX Flags: 0x2
2006-09-07 03:05:18.92 spid4     Grant List 1::
2006-09-07 03:05:18.92 spid4     Owner:0x292a7440 Mode: IX       Flg:0x0 Ref:1 Life:02000000 SPID:181 ECID:0
2006-09-07 03:05:18.92 spid4     SPID: 181 ECID: 0 Statement Type: UPDATE Line #: 260
2006-09-07 03:05:18.92 spid4     Input Buf: RPC Event: sp_Upd;1
2006-09-07 03:05:18.92 spid4     Grant List 2::
2006-09-07 03:05:18.92 spid4     Requested By:
2006-09-07 03:05:18.92 spid4     ResType:LockOwner Stype:'OR' Mode: S SPID:62 ECID:0 Ec0x2C2D75A0) Value:0x7877bfa0 Cost0/0)
2006-09-07 03:05:18.92 spid4
2006-09-07 03:05:18.92 spid4     Node:2
2006-09-07 03:05:18.92 spid4     KEY: 9:453576654:1 (6100f6c31ca6) CleanCnt:3 Mode: U Flags: 0x0
2006-09-07 03:05:18.92 spid4     Convert List:
2006-09-07 03:05:18.92 spid4     Owner:0x28d98fa0 Mode: X        Flg:0x2 Ref:1 Life:02000000 SPID:210 ECID:0
2006-09-07 03:05:18.92 spid4     SPID: 210 ECID: 0 Statement Type: UPDATE Line #: 1
2006-09-07 03:05:18.92 spid4     Input Buf: RPC Event: sp_upd_Finished;1
2006-09-07 03:05:18.92 spid4     Requested By:
2006-09-07 03:05:18.92 spid4        ResType:LockOwner Stype:'OR' Mode: X SPID:181 ECID:0 Ec0x5D6435A0) Value:0x787ad1c0 Cost0/0)
2006-09-07 03:05:18.92 spid4
2006-09-07 03:05:18.92 spid4     Node:3
2006-09-07 03:05:18.92 spid4     KEY: 9:453576654:1 (6100f6c31ca6) CleanCnt:3 Mode: U Flags: 0x0
2006-09-07 03:05:18.92 spid4      Grant List 1::
2006-09-07 03:05:18.92 spid4        Owner:0x327cc680 Mode: S        Flg:0x0 Ref:1 Life:00000000 SPID:81 ECID:0
2006-09-07 03:05:18.92 spid4        SPID: 81 ECID: 0 Statement Type: SELECT Line #: 1
2006-09-07 03:05:18.92 spid4        Input Buf: RPC Event: sp_Sea_Sel;1
2006-09-07 03:05:18.92 spid4      Grant List 2::
2006-09-07 03:05:18.92 spid4      Requested By:
2006-09-07 03:05:18.92 spid4        ResType:LockOwner Stype:'OR' Mode: X SPID:210 ECID:0 Ec0x1EF9D5A0) Value:0x28d98fa0 Cost0/1BC)
2006-09-07 03:05:18.92 spid4
2006-09-07 03:05:18.92 spid4     Node:4
2006-09-07 03:05:18.92 spid4     PAG: 9:1:5151886               CleanCnt:3 Mode: IX Flags: 0x2
2006-09-07 03:05:18.92 spid4      Wait List:
2006-09-07 03:05:18.92 spid4        Owner:0x7877bfa0 Mode: S        Flg:0x0 Ref:1 Life:00000000 SPID:62 ECID:0
2006-09-07 03:05:18.92 spid4        SPID: 62 ECID: 0 Statement Type: SELECT Line #: 6
2006-09-07 03:05:18.92 spid4        Input Buf: RPC Event: sp_sel_ToSam;1
2006-09-07 03:05:18.92 spid4      Requested By:
2006-09-07 03:05:18.92 spid4        ResType:LockOwner Stype:'OR' Mode: IS SPID:81 ECID:0 Ec0x403995A0) Value:0x1e480020 Cost0/0)
2006-09-07 03:05:18.92 spid4     Victim Resource Owner:
2006-09-07 03:05:18.92 spid4      ResType:LockOwner Stype:'OR' Mode: IS SPID:81 ECID:0 Ec0x403995A0) Value:0x1e480020 Cost0/0)
2006-09-07 03:05:18.92 spid4
Thanks in ADVANCE!
September 11, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 1

here you can find detail

http://colleenmorrow.com/2011/03/01/deadlocks-and-trace-flag-1204/