deadlock wait-for graph key

• sql007

  Say Hey Kid

  Points: 680

  More actions

  December 13, 2013 at 3:50 pm

  #302253

  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 TaskProxy:(0x0000000084C00598) Value:0x14b6b640 Cost:(0/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 TaskProxy:(0x000000084D522598) Value:0x4ae00bc0 Cost:(0/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 TaskProxy:(0x0000000084C00598) Value:0x14b6b640 Cost:(0/1628)

  (23 rows affected)