Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

deadlock wait-for graph key Expand / Collapse
Author
Message
Posted Friday, December 13, 2013 3:50 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 11, 2014 11:02 AM
Points: 83, Visits: 211
Hi,
Just took over as a dba, so I am getting deadlock alerts and I would like to read this graph, but I have seen tutorial on a different type of key format. My format seems to have really long object id's.

how would I interpret this log. I would like to get the queries that were involved if possible.


logdate procInfo ERRORLOG
----------------------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2013-12-13 16:42:33.500 spid18s Deadlock encountered .... Printing deadlock information
2013-12-13 16:42:33.500 spid18s Wait-for graph
2013-12-13 16:42:33.500 spid18s NULL
2013-12-13 16:42:33.500 spid18s Node:1

2013-12-13 16:42:33.500 spid18s KEY: 10:72057594043105280 (1a0135bddc71) CleanCnt:3 Mode:X Flags: 0x0
2013-12-13 16:42:33.500 spid18s Grant List 1:
2013-12-13 16:42:33.500 spid18s Owner:0x00000000190BCB40 Mode: X Flg:0x0 Ref:0 Life:02000001 SPID:146 ECID:0 XactLockInfo: 0x0000000730A803A8
2013-12-13 16:42:33.500 spid18s SPID: 146 ECID: 0 Statement Type: DELETE Line #: 187
2013-12-13 16:42:33.500 spid18s Input Buf: RPC Event: Proc [Database Id = 10 Object Id = 1234103437]
2013-12-13 16:42:33.500 spid18s Requested By:
2013-12-13 16:42:33.500 spid18s ResType:LockOwner Stype:'OR'Xdes:0x00000009E4617AB0 Mode: S SPID:147 BatchID:0 ECID:0 TaskProxy0x0000000084C00598) Value:0x14b6b640 Cost0/1628)
2013-12-13 16:42:33.500 spid18s NULL
2013-12-13 16:42:33.500 spid18s Node:2

2013-12-13 16:42:33.500 spid18s KEY: 10:72057594043105280 (a20113fc2e64) CleanCnt:2 Mode:X Flags: 0x0
2013-12-13 16:42:33.500 spid18s Grant List 1:
2013-12-13 16:42:33.500 spid18s Owner:0x0000000014F8EE80 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:147 ECID:0 XactLockInfo: 0x00000009E4617AE8
2013-12-13 16:42:33.500 spid18s SPID: 147 ECID: 0 Statement Type: UPDATE Line #: 1
2013-12-13 16:42:33.510 spid18s Input Buf: RPC Event: Proc [Database Id = 10 Object Id = 1346103836]
2013-12-13 16:42:33.510 spid18s Requested By:
2013-12-13 16:42:33.510 spid18s ResType:LockOwner Stype:'OR'Xdes:0x0000000730A80370 Mode: U SPID:146 BatchID:0 ECID:0 TaskProxy0x000000084D522598) Value:0x4ae00bc0 Cost0/4520)
2013-12-13 16:42:33.510 spid18s NULL
2013-12-13 16:42:33.510 spid18s Victim Resource Owner:
2013-12-13 16:42:33.510 spid18s ResType:LockOwner Stype:'OR'Xdes:0x00000009E4617AB0 Mode: S SPID:147 BatchID:0 ECID:0 TaskProxy0x0000000084C00598) Value:0x14b6b640 Cost0/1628)


(23 rows affected)
Post #1522883
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse