Help Me read the data collected from Trace Flag 1204

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:6
2
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 SPI
D:
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 SPI
D:
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!
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1read this article.
http://msdn.microsoft.com/library/d...
tabse_5xrn.asp
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"msqldba via droptable.com" <u11604@.uwe> wrote in message
news:65fced5a1d92d@.uwe...
> 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!
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1
>

Help Me read the data collected from Trace Flag 1204

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!
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1read this article.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_5xrn.asp
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"msqldba via SQLMonster.com" <u11604@.uwe> wrote in message
news:65fced5a1d92d@.uwe...
> 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!
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1
>