Sunday, February 19, 2012

Interpreting deadlock info

I have a trace flag 1204 on my sql2k box. It prints out deadlock info
when they occur. I got the dump below. My question is how to interpret
a line like
RID: 9:1:587432:0
I know how to interpret lines that start with KEY:, but not RID and I
can't find any documentation.
Wait-for graph
Node:1
RID: 9:1:587432:0 CleanCnt:2 Mode: X Flags: 0x2
Grant List 3::
Owner:0x21e53740 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:193
ECID:0RID is row ID, the format is DBID:FILEID:PAGEID:ROWNUM
Using DBCC PAGE that I mentioned in my reply to your other post, you can see
the actual rows on the page.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Frank Rizzo" <none@.none.com> wrote in message
news:OnTG6fhIGHA.3408@.TK2MSFTNGP12.phx.gbl...
>I have a trace flag 1204 on my sql2k box. It prints out deadlock info when
>they occur. I got the dump below. My question is how to interpret a line
>like
> RID: 9:1:587432:0
> I know how to interpret lines that start with KEY:, but not RID and I
> can't find any documentation.
> Wait-for graph
> Node:1
> RID: 9:1:587432:0 CleanCnt:2 Mode: X Flags: 0x2
> Grant List 3::
> Owner:0x21e53740 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:193
> ECID:0
>

No comments:

Post a Comment