Interpreting deadlock info

26 Jan 2006 1:29 AM

Frank Rizzo

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

26 Jan 2006 2:28 AM

Kalen Delaney

RID 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

Show quoteHide quote

"Frank Rizzo" <n***@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
>