How analysing SQL Server log to correct Navision code

I need to exam the SQL Server log to find the reasons of some deadlocks
occured for a Navision application.
I use SQL Server 2000 and Navision 3.70a. I have experience about SQL Server
but not Navision.
I have already some documentation about SQL Server log. I have used the
parameters /T1204 e /T3605 to enable a trace in the log.
Now, I want to find the rigth point inside environment Navision where the
code must be modified.
Below, I put the deadlock information registered:
Node:1
2006-10-23 15:41:48.62 spid4 KEY: 7:1829581556:1 (1500fdbebb1d)
CleanCnt:1 Mode: Range-S-U Flags: 0x0
2006-10-23 15:41:48.62 spid4 Grant List 1::
2006-10-23 15:41:48.62 spid4 Owner:0x5d140580 Mode: Range-S-U Flg:0x0
Ref:1 Life:02000000 SPID:56 ECID:0
2006-10-23 15:41:48.62 spid4 SPID: 56 ECID: 0 Statement Type: SELECT
Line #: 1
2006-10-23 15:41:48.62 spid4 Input Buf: RPC Event: sp_prepexec;1
2006-10-23 15:41:48.62 spid4 Requested By:
2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode:
Range-S-U SPID:63 ECID:0 Ec:(0x5D98D550) Value:0x5cc8d000 Cost:(0/0)
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:2
2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
ECID: 0, Not Blocking
2006-10-23 15:41:48.62 spid4 Consumer List::
2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
SPID: 56, ECID: 0, Blocking
2006-10-23 15:41:48.62 spid4 Producer List::
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
SPID: 56, ECID: 2, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
SPID: 56, ECID: 4, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
SPID: 56, ECID: 1, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
SPID: 56, ECID: 3, Blocking
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:3
2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
Mode: IU Flags: 0x2
2006-10-23 15:41:48.62 spid4 Wait List:
2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U Flg:0x0
Ref:1 Life:02000000 SPID:56 ECID:1
2006-10-23 15:41:48.62 spid4 Requested By:
2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
SPID:56 ECID:2 Ec:(0x23790098) Value:0x5cbd0e20 Cost:(0/1A68)
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:4
2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
Mode: IU Flags: 0x2
2006-10-23 15:41:48.62 spid4 Grant List 0::
2006-10-23 15:41:48.62 spid4 Owner:0x5d007180 Mode: IU Flg:0x0
Ref:1 Life:02000000 SPID:63 ECID:0
2006-10-23 15:41:48.62 spid4 SPID: 63 ECID: 0 Statement Type: UPDATE
Line #: 1
2006-10-23 15:41:48.62 spid4 Input Buf: RPC Event: sp_execute;1
2006-10-23 15:41:48.62 spid4 Grant List 1::
2006-10-23 15:41:48.62 spid4 Requested By:
2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
SPID:56 ECID:1 Ec:(0x2379E098) Value:0x5cbd0de0 Cost:(0/1A68)
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 -- next branch --
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:2
2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
ECID: 0, Not Blocking
2006-10-23 15:41:48.62 spid4 Consumer List::
2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
SPID: 56, ECID: 0, Blocking
2006-10-23 15:41:48.62 spid4 Producer List::
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
SPID: 56, ECID: 2, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
SPID: 56, ECID: 4, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
SPID: 56, ECID: 1, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
SPID: 56, ECID: 3, Blocking
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:7
2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
Mode: IU Flags: 0x2
2006-10-23 15:41:48.62 spid4 Wait List:
2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U Flg:0x0
Ref:1 Life:02000000 SPID:56 ECID:1
2006-10-23 15:41:48.62 spid4 Requested By:
2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
SPID:56 ECID:4 Ec:(0x23786098) Value:0x5cbd0e40 Cost:(0/1A68)
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 -- next branch --
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:2
2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
ECID: 0, Not Blocking
2006-10-23 15:41:48.62 spid4 Consumer List::
2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
SPID: 56, ECID: 0, Blocking
2006-10-23 15:41:48.62 spid4 Producer List::
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
SPID: 56, ECID: 2, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
SPID: 56, ECID: 4, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
SPID: 56, ECID: 1, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
SPID: 56, ECID: 3, Blocking
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 -- next branch --
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:2
2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
ECID: 0, Not Blocking
2006-10-23 15:41:48.62 spid4 Consumer List::
2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
SPID: 56, ECID: 0, Blocking
2006-10-23 15:41:48.62 spid4 Producer List::
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
SPID: 56, ECID: 2, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
SPID: 56, ECID: 4, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
SPID: 56, ECID: 1, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
SPID: 56, ECID: 3, Blocking
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:12
2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
Mode: IU Flags: 0x2
2006-10-23 15:41:48.62 spid4 Wait List:
2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U Flg:0x0
Ref:1 Life:02000000 SPID:56 ECID:1
2006-10-23 15:41:48.62 spid4 Requested By:
2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
SPID:56 ECID:3 Ec:(0x2378E098) Value:0x5cbd0e00 Cost:(0/1A68)
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 -- next branch --
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4
2006-10-23 15:41:48.62 spid4 Node:2
2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
ECID: 0, Not Blocking
2006-10-23 15:41:48.62 spid4 Consumer List::
2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
SPID: 56, ECID: 0, Blocking
2006-10-23 15:41:48.62 spid4 Producer List::
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
SPID: 56, ECID: 2, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
SPID: 56, ECID: 4, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
SPID: 56, ECID: 1, Blocking
2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
SPID: 56, ECID: 3, Blocking
2006-10-23 15:41:48.62 spid4 Victim Resource Owner:
2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode:
Range-S-U SPID:63 ECID:0 Ec:(0x5D98D550) Value:0x5cc8d000 Cost:(0/0)
I don't know the meanings or the goal of some terms: Life? Stype? EC? Xid
Slot? e_etypeOpenWorkers?
I want to help my Navision programmers and so I want to indicate some
suggests to solve this issue.
Many thanksWhat is Navision 3.70a?
Its more info about SQL Server 2005, but there are some links to SQL Server
2000 as well
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:1E5B01B8-62BE-4BB8-9855-8782B5BC7875@.microsoft.com...
>I need to exam the SQL Server log to find the reasons of some deadlocks
> occured for a Navision application.
> I use SQL Server 2000 and Navision 3.70a. I have experience about SQL
> Server
> but not Navision.
> I have already some documentation about SQL Server log. I have used the
> parameters /T1204 e /T3605 to enable a trace in the log.
> Now, I want to find the rigth point inside environment Navision where the
> code must be modified.
> Below, I put the deadlock information registered:
> Node:1
> 2006-10-23 15:41:48.62 spid4 KEY: 7:1829581556:1 (1500fdbebb1d)
> CleanCnt:1 Mode: Range-S-U Flags: 0x0
> 2006-10-23 15:41:48.62 spid4 Grant List 1::
> 2006-10-23 15:41:48.62 spid4 Owner:0x5d140580 Mode: Range-S-U
> Flg:0x0
> Ref:1 Life:02000000 SPID:56 ECID:0
> 2006-10-23 15:41:48.62 spid4 SPID: 56 ECID: 0 Statement Type:
> SELECT
> Line #: 1
> 2006-10-23 15:41:48.62 spid4 Input Buf: RPC Event: sp_prepexec;1
> 2006-10-23 15:41:48.62 spid4 Requested By:
> 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode:
> Range-S-U SPID:63 ECID:0 Ec:(0x5D98D550) Value:0x5cc8d000 Cost:(0/0)
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:2
> 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> ECID: 0, Not Blocking
> 2006-10-23 15:41:48.62 spid4 Consumer List::
> 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> SPID: 56, ECID: 0, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer List::
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> SPID: 56, ECID: 2, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> SPID: 56, ECID: 4, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> SPID: 56, ECID: 1, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> SPID: 56, ECID: 3, Blocking
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:3
> 2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
> Mode: IU Flags: 0x2
> 2006-10-23 15:41:48.62 spid4 Wait List:
> 2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U
> Flg:0x0
> Ref:1 Life:02000000 SPID:56 ECID:1
> 2006-10-23 15:41:48.62 spid4 Requested By:
> 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
> SPID:56 ECID:2 Ec:(0x23790098) Value:0x5cbd0e20 Cost:(0/1A68)
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:4
> 2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
> Mode: IU Flags: 0x2
> 2006-10-23 15:41:48.62 spid4 Grant List 0::
> 2006-10-23 15:41:48.62 spid4 Owner:0x5d007180 Mode: IU
> Flg:0x0
> Ref:1 Life:02000000 SPID:63 ECID:0
> 2006-10-23 15:41:48.62 spid4 SPID: 63 ECID: 0 Statement Type:
> UPDATE
> Line #: 1
> 2006-10-23 15:41:48.62 spid4 Input Buf: RPC Event: sp_execute;1
> 2006-10-23 15:41:48.62 spid4 Grant List 1::
> 2006-10-23 15:41:48.62 spid4 Requested By:
> 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
> SPID:56 ECID:1 Ec:(0x2379E098) Value:0x5cbd0de0 Cost:(0/1A68)
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 -- next branch --
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:2
> 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> ECID: 0, Not Blocking
> 2006-10-23 15:41:48.62 spid4 Consumer List::
> 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> SPID: 56, ECID: 0, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer List::
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> SPID: 56, ECID: 2, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> SPID: 56, ECID: 4, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> SPID: 56, ECID: 1, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> SPID: 56, ECID: 3, Blocking
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:7
> 2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
> Mode: IU Flags: 0x2
> 2006-10-23 15:41:48.62 spid4 Wait List:
> 2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U
> Flg:0x0
> Ref:1 Life:02000000 SPID:56 ECID:1
> 2006-10-23 15:41:48.62 spid4 Requested By:
> 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
> SPID:56 ECID:4 Ec:(0x23786098) Value:0x5cbd0e40 Cost:(0/1A68)
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 -- next branch --
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:2
> 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> ECID: 0, Not Blocking
> 2006-10-23 15:41:48.62 spid4 Consumer List::
> 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> SPID: 56, ECID: 0, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer List::
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> SPID: 56, ECID: 2, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> SPID: 56, ECID: 4, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> SPID: 56, ECID: 1, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> SPID: 56, ECID: 3, Blocking
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 -- next branch --
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:2
> 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> ECID: 0, Not Blocking
> 2006-10-23 15:41:48.62 spid4 Consumer List::
> 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> SPID: 56, ECID: 0, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer List::
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> SPID: 56, ECID: 2, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> SPID: 56, ECID: 4, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> SPID: 56, ECID: 1, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> SPID: 56, ECID: 3, Blocking
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:12
> 2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
> Mode: IU Flags: 0x2
> 2006-10-23 15:41:48.62 spid4 Wait List:
> 2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U
> Flg:0x0
> Ref:1 Life:02000000 SPID:56 ECID:1
> 2006-10-23 15:41:48.62 spid4 Requested By:
> 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
> SPID:56 ECID:3 Ec:(0x2378E098) Value:0x5cbd0e00 Cost:(0/1A68)
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 -- next branch --
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4
> 2006-10-23 15:41:48.62 spid4 Node:2
> 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> ECID: 0, Not Blocking
> 2006-10-23 15:41:48.62 spid4 Consumer List::
> 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> SPID: 56, ECID: 0, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer List::
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> SPID: 56, ECID: 2, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> SPID: 56, ECID: 4, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> SPID: 56, ECID: 1, Blocking
> 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> SPID: 56, ECID: 3, Blocking
> 2006-10-23 15:41:48.62 spid4 Victim Resource Owner:
> 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode:
> Range-S-U SPID:63 ECID:0 Ec:(0x5D98D550) Value:0x5cc8d000 Cost:(0/0)
> I don't know the meanings or the goal of some terms: Life? Stype? EC? Xid
> Slot? e_etypeOpenWorkers?
> I want to help my Navision programmers and so I want to indicate some
> suggests to solve this issue.
> Many thanks
>
>|||Navision is the Microsoft ERP. Now its name is Dynamics NAV.
"Uri Dimant" wrote:
> What is Navision 3.70a?
> Its more info about SQL Server 2005, but there are some links to SQL Server
> 2000 as well
> http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
>
>
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:1E5B01B8-62BE-4BB8-9855-8782B5BC7875@.microsoft.com...
> >I need to exam the SQL Server log to find the reasons of some deadlocks
> > occured for a Navision application.
> > I use SQL Server 2000 and Navision 3.70a. I have experience about SQL
> > Server
> > but not Navision.
> > I have already some documentation about SQL Server log. I have used the
> > parameters /T1204 e /T3605 to enable a trace in the log.
> > Now, I want to find the rigth point inside environment Navision where the
> > code must be modified.
> >
> > Below, I put the deadlock information registered:
> > Node:1
> > 2006-10-23 15:41:48.62 spid4 KEY: 7:1829581556:1 (1500fdbebb1d)
> > CleanCnt:1 Mode: Range-S-U Flags: 0x0
> > 2006-10-23 15:41:48.62 spid4 Grant List 1::
> > 2006-10-23 15:41:48.62 spid4 Owner:0x5d140580 Mode: Range-S-U
> > Flg:0x0
> > Ref:1 Life:02000000 SPID:56 ECID:0
> > 2006-10-23 15:41:48.62 spid4 SPID: 56 ECID: 0 Statement Type:
> > SELECT
> > Line #: 1
> > 2006-10-23 15:41:48.62 spid4 Input Buf: RPC Event: sp_prepexec;1
> > 2006-10-23 15:41:48.62 spid4 Requested By:
> > 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode:
> > Range-S-U SPID:63 ECID:0 Ec:(0x5D98D550) Value:0x5cc8d000 Cost:(0/0)
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:2
> > 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> > 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> > 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> > ECID: 0, Not Blocking
> > 2006-10-23 15:41:48.62 spid4 Consumer List::
> > 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> > SPID: 56, ECID: 0, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer List::
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> > SPID: 56, ECID: 2, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> > SPID: 56, ECID: 4, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> > SPID: 56, ECID: 1, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> > SPID: 56, ECID: 3, Blocking
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:3
> > 2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
> > Mode: IU Flags: 0x2
> > 2006-10-23 15:41:48.62 spid4 Wait List:
> > 2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U
> > Flg:0x0
> > Ref:1 Life:02000000 SPID:56 ECID:1
> > 2006-10-23 15:41:48.62 spid4 Requested By:
> > 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
> > SPID:56 ECID:2 Ec:(0x23790098) Value:0x5cbd0e20 Cost:(0/1A68)
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:4
> > 2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
> > Mode: IU Flags: 0x2
> > 2006-10-23 15:41:48.62 spid4 Grant List 0::
> > 2006-10-23 15:41:48.62 spid4 Owner:0x5d007180 Mode: IU
> > Flg:0x0
> > Ref:1 Life:02000000 SPID:63 ECID:0
> > 2006-10-23 15:41:48.62 spid4 SPID: 63 ECID: 0 Statement Type:
> > UPDATE
> > Line #: 1
> > 2006-10-23 15:41:48.62 spid4 Input Buf: RPC Event: sp_execute;1
> > 2006-10-23 15:41:48.62 spid4 Grant List 1::
> > 2006-10-23 15:41:48.62 spid4 Requested By:
> > 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
> > SPID:56 ECID:1 Ec:(0x2379E098) Value:0x5cbd0de0 Cost:(0/1A68)
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 -- next branch --
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:2
> > 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> > 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> > 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> > ECID: 0, Not Blocking
> > 2006-10-23 15:41:48.62 spid4 Consumer List::
> > 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> > SPID: 56, ECID: 0, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer List::
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> > SPID: 56, ECID: 2, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> > SPID: 56, ECID: 4, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> > SPID: 56, ECID: 1, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> > SPID: 56, ECID: 3, Blocking
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:7
> > 2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
> > Mode: IU Flags: 0x2
> > 2006-10-23 15:41:48.62 spid4 Wait List:
> > 2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U
> > Flg:0x0
> > Ref:1 Life:02000000 SPID:56 ECID:1
> > 2006-10-23 15:41:48.62 spid4 Requested By:
> > 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
> > SPID:56 ECID:4 Ec:(0x23786098) Value:0x5cbd0e40 Cost:(0/1A68)
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 -- next branch --
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:2
> > 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> > 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> > 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> > ECID: 0, Not Blocking
> > 2006-10-23 15:41:48.62 spid4 Consumer List::
> > 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> > SPID: 56, ECID: 0, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer List::
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> > SPID: 56, ECID: 2, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> > SPID: 56, ECID: 4, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> > SPID: 56, ECID: 1, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> > SPID: 56, ECID: 3, Blocking
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 -- next branch --
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:2
> > 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> > 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> > 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> > ECID: 0, Not Blocking
> > 2006-10-23 15:41:48.62 spid4 Consumer List::
> > 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> > SPID: 56, ECID: 0, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer List::
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> > SPID: 56, ECID: 2, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> > SPID: 56, ECID: 4, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> > SPID: 56, ECID: 1, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> > SPID: 56, ECID: 3, Blocking
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:12
> > 2006-10-23 15:41:48.62 spid4 PAG: 7:3:526003 CleanCnt:4
> > Mode: IU Flags: 0x2
> > 2006-10-23 15:41:48.62 spid4 Wait List:
> > 2006-10-23 15:41:48.62 spid4 Owner:0x5cbd0de0 Mode: U
> > Flg:0x0
> > Ref:1 Life:02000000 SPID:56 ECID:1
> > 2006-10-23 15:41:48.62 spid4 Requested By:
> > 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode: U
> > SPID:56 ECID:3 Ec:(0x2378E098) Value:0x5cbd0e00 Cost:(0/1A68)
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 -- next branch --
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4
> > 2006-10-23 15:41:48.62 spid4 Node:2
> > 2006-10-23 15:41:48.62 spid4 Port: 0x42bf0100 Xid Slot: 0, EC:
> > 0x72dd7550, ECID: 0 (Coordinator), Exchange Wait Type :e_etypeOpenWorkers
> > 2006-10-23 15:41:48.62 spid4 Coordinator: EC = 0x72dd7550, SPID: 56,
> > ECID: 0, Not Blocking
> > 2006-10-23 15:41:48.62 spid4 Consumer List::
> > 2006-10-23 15:41:48.62 spid4 Consumer: Xid Slot: 0, EC = 0x72dd7550,
> > SPID: 56, ECID: 0, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer List::
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 1, EC = 0x23790098,
> > SPID: 56, ECID: 2, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 2, EC = 0x23786098,
> > SPID: 56, ECID: 4, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 3, EC = 0x2379e098,
> > SPID: 56, ECID: 1, Blocking
> > 2006-10-23 15:41:48.62 spid4 Producer: Xid Slot: 4, EC = 0x2378e098,
> > SPID: 56, ECID: 3, Blocking
> > 2006-10-23 15:41:48.62 spid4 Victim Resource Owner:
> > 2006-10-23 15:41:48.62 spid4 ResType:LockOwner Stype:'OR' Mode:
> > Range-S-U SPID:63 ECID:0 Ec:(0x5D98D550) Value:0x5cc8d000 Cost:(0/0)
> >
> > I don't know the meanings or the goal of some terms: Life? Stype? EC? Xid
> > Slot? e_etypeOpenWorkers?
> >
> > I want to help my Navision programmers and so I want to indicate some
> > suggests to solve this issue.
> >
> > Many thanks
> >
> >
> >
> >
>
>