MS SQL Server - Interpreting deadlock info

Author

Interpreting deadlock info

Frank Rizzo

2006-01-26, 4:53 pm

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

Kalen Delaney

2006-01-26, 4:53 pm

RID is row ID, the format is DBID:FILEID:PAGEID:R
OWNUM

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
>

Sponsored Links