Loggin Deadlocks

[johnny76]

Hi again,

Can someone help me understand how to probperly read the information in a deadlock...

ResType:LockOwner Stype:'OR' Mode: IX SPID:68 ECID:0 Ec:(0x51913598) Value:0x5b081bc0 Cost:(0/0)

Victim Resource Owner:

ResType:LockOwner Stype:'OR' Mode: IX SPID:68 ECID:0 Ec:(0x51913598) Value:0x5b081bc0 Cost:(0/0)

Requested By: 

Input Buf: RPC Event: SB_IVR_DIALER.dbo.[STOREDPROCEDURE];1

SPID: 56 ECID: 0 Statement Type: UPDATE Line #: 29

Owner:0x4ea7ec80 Mode: S        Flg:0x0 Ref:0 Life:00000001 SPID:56 ECID:0

Grant List 2::

PAG: 9:1:236473                CleanCnt:2 Mode: SIU Flags: 0x2

Node:2

ResType:LockOwner Stype:'OR' Mode: IX SPID:56 ECID:0 Ec:(0x6D08F598) Value:0x60464620 Cost:(0/0)

Requested By: 

Input Buf: RPC Event: SB_IVR_DIALER.dbo.[STOREDPROCEDURE];1

SPID: 68 ECID: 0 Statement Type: UPDATE Line #: 29

Owner:0x68e89220 Mode: S        Flg:0x0 Ref:0 Life:00000001 SPID:68 ECID:0

Grant List 2::

PAG: 9:1:236473                CleanCnt:2 Mode: SIU Flags: 0x2

Node:1

Wait-for graph

Deadlock encountered .... Printing deadlock information

I can see what sp it causeing it...and I see that it is a page lock...I think I need to know how I should go about debugging this log entry...any suggestions...maybe even a good tutorial...I have looked at a number of them but they have not been clear enough..

CES

 

[SQLDenis]

Here is a start

http://support.microsoft.com/default.aspx?scid=kb;en-us;832524

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[johnny76]

Thanks for post.
I read through this and a number of other pages but I find a bit difficult to find a site that really helpps you read the log. I have learned a lot about deadlocks and what there are/how they happen but understanding the log has been a little tricky...do you have any other sites oyu can suggest?

CRES