I asked the DBA to start the Server with options -T1204 and -T3605 and
here's what I get. I need help deciphering this. This happens when we
have 5 usrs performing concurrent actions and for the life of me cannot
decipher this. WHat is a Node, what is the branch ?
WHat are the ECIDs. I cannot even easily find out what process blocks
what. Does anyone have any experience with these. ANy and all help will
be appreaciated. I have posted the output of one of the many deadlocks
encountered. Thanks

Deadlock encountered .... Printing deadlock information
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Wait-for graph
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:1
2005-01-11 08:49:59.49 spid4 Port: 0x42bf0280 Xid Slot: 0, EC:
0x46d09590, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2005-01-11 08:49:59.49 spid4 SPID: 61 ECID: 0 Statement Type:
SELECT Line #: 651
2005-01-11 08:49:59.49 spid4 Input Buf: RPC Event:
Procedure_GetLatestValues;1
2005-01-11 08:49:59.49 spid4 Coordinator: EC = 0x46d09590, SPID:
61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Consumer List::
2005-01-11 08:49:59.49 spid4 Consumer: Xid Slot: 0, EC =
0x46d09590, SPID: 61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Producer List::
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 1, EC =
0x4732c098, SPID: 61, ECID: 6, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 2, EC =
0x46824098, SPID: 61, ECID: 5, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 3, EC =
0x47296098, SPID: 61, ECID: 7, Blocking
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:2
2005-01-11 08:49:59.49 spid4 PAG: 7:1:405367
CleanCnt:3 Mode: IX Flags: 0x2
2005-01-11 08:49:59.49 spid4 Grant List 1::
2005-01-11 08:49:59.49 spid4 Grant List 3::
2005-01-11 08:49:59.49 spid4 Owner:0x4ed4b8e0 Mode: IX
Flg:0x0 Ref:1 Life:02000000 SPID:64 ECID:0
2005-01-11 08:49:59.49 spid4 SPID: 64 ECID: 0 Statement Type:
UPDATE Line #: 1
2005-01-11 08:49:59.49 spid4 Input Buf: RPC Event:
Standard_InsertNamePair;1
2005-01-11 08:49:59.49 spid4 Requested By:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:61 ECID:6 Ec0x4732C098) Value:0x4aafe660 Cost0/A6C)
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:3
2005-01-11 08:49:59.49 spid4 PAG: 7:1:405373
CleanCnt:1 Mode: IX Flags: 0x2
2005-01-11 08:49:59.49 spid4 Grant List 1::
2005-01-11 08:49:59.49 spid4 Owner:0x4ac00160 Mode: IX
Flg:0x0 Ref:1 Life:02000000 SPID:61 ECID:0
2005-01-11 08:49:59.49 spid4 Requested By:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode:
U SPID:64 ECID:0 Ec0x472F3590) Value:0x46c24a40 Cost0/A38)
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 -- next branch --
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:1
2005-01-11 08:49:59.49 spid4 Port: 0x42bf0280 Xid Slot: 0, EC:
0x46d09590, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2005-01-11 08:49:59.49 spid4 Coordinator: EC = 0x46d09590, SPID:
61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Consumer List::
2005-01-11 08:49:59.49 spid4 Consumer: Xid Slot: 0, EC =
0x46d09590, SPID: 61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Producer List::
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 1, EC =
0x4732c098, SPID: 61, ECID: 6, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 2, EC =
0x46824098, SPID: 61, ECID: 5, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 3, EC =
0x47296098, SPID: 61, ECID: 7, Blocking
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:6
2005-01-11 08:49:59.49 spid4 PAG: 7:1:405367
CleanCnt:3 Mode: IX Flags: 0x2
2005-01-11 08:49:59.49 spid4 Wait List:
2005-01-11 08:49:59.49 spid4 Owner:0x4aafe660 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:61 ECID:6
2005-01-11 08:49:59.49 spid4 Requested By:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:61 ECID:5 Ec0x46824098) Value:0x4edc4d80 Cost0/A6C)
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 -- next branch --
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:1
2005-01-11 08:49:59.49 spid4 Port: 0x42bf0280 Xid Slot: 0, EC:
0x46d09590, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2005-01-11 08:49:59.49 spid4 Coordinator: EC = 0x46d09590, SPID:
61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Consumer List::
2005-01-11 08:49:59.49 spid4 Consumer: Xid Slot: 0, EC =
0x46d09590, SPID: 61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Producer List::
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 1, EC =
0x4732c098, SPID: 61, ECID: 6, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 2, EC =
0x46824098, SPID: 61, ECID: 5, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 3, EC =
0x47296098, SPID: 61, ECID: 7, Blocking
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:9
2005-01-11 08:49:59.49 spid4 PAG: 7:1:405367
CleanCnt:3 Mode: IX Flags: 0x2
2005-01-11 08:49:59.49 spid4 Wait List:
2005-01-11 08:49:59.49 spid4 Owner:0x4aafe660 Mode: S
Flg:0x0 Ref:1 Life:00000000 SPID:61 ECID:6
2005-01-11 08:49:59.49 spid4 Requested By:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode:
S SPID:61 ECID:7 Ec0x47296098) Value:0x42bef7c0 Cost0/A6C)
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 -- next branch --
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4
2005-01-11 08:49:59.49 spid4 Node:1
2005-01-11 08:49:59.49 spid4 Port: 0x42bf0280 Xid Slot: 0, EC:
0x46d09590, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeCXPacket
2005-01-11 08:49:59.49 spid4 Coordinator: EC = 0x46d09590, SPID:
61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Consumer List::
2005-01-11 08:49:59.49 spid4 Consumer: Xid Slot: 0, EC =
0x46d09590, SPID: 61, ECID: 0, Not Blocking
2005-01-11 08:49:59.49 spid4 Producer List::
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 1, EC =
0x4732c098, SPID: 61, ECID: 6, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 2, EC =
0x46824098, SPID: 61, ECID: 5, Blocking
2005-01-11 08:49:59.49 spid4 Producer: Xid Slot: 3, EC =
0x47296098, SPID: 61, ECID: 7, Blocking
2005-01-11 08:49:59.49 spid4 Victim Resource Owner:
2005-01-11 08:49:59.49 spid4 ResType:LockOwner Stype:'OR' Mode: U
SPID:64 ECID:0 Ec0x472F3590) Value:0x46c24a40 Cost0/A38)
2005-01-11 08:50:15.11 spid4