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
>

Interpret Agent Log Entry

The log entry
2006-09-19 21:16:06 - + [000] Request to run job
0x6A98EE728DB2FC498C379735F3CE7567 (from Alert 11) refused
appears in our SQL Server Agent log. I'm try to track the source. So I'm
wondering what the hex value refer to and the bit "(from Alert 11)".
Thanks,
TomHard to say, could you query select * from msdb.dbo.sysjobs where
jobid=0x6A98EE728DB2FC498C379735F3CE7567
to determine which job this id belongs to
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:40AB8EB6-A0F7-40BF-93D3-ABBBB73F9706@.microsoft.com...
> The log entry
> 2006-09-19 21:16:06 - + [000] Request to run job
> 0x6A98EE728DB2FC498C379735F3CE7567 (from Alert 11) refused
> appears in our SQL Server Agent log. I'm try to track the source. So I'm
> wondering what the hex value refer to and the bit "(from Alert 11)".
> Thanks,
> Tom

Interpret Agent Log Entry

The log entry
2006-09-19 21:16:06 - + [000] Request to run job
0x6A98EE728DB2FC498C379735F3CE7567 (from Alert 11) refused
appears in our SQL Server Agent log. I'm try to track the source. So I'm
wondering what the hex value refer to and the bit "(from Alert 11)".
Thanks,
TomHard to say, could you query select * from msdb.dbo.sysjobs where
jobid=0x6A98EE728DB2FC498C379735F3CE7567
to determine which job this id belongs to
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:40AB8EB6-A0F7-40BF-93D3-ABBBB73F9706@.microsoft.com...
> The log entry
> 2006-09-19 21:16:06 - + [000] Request to run job
> 0x6A98EE728DB2FC498C379735F3CE7567 (from Alert 11) refused
> appears in our SQL Server Agent log. I'm try to track the source. So I'm
> wondering what the hex value refer to and the bit "(from Alert 11)".
> Thanks,
> Tom

Interpret Agent Log Entry

The log entry
2006-09-19 21:16:06 - + [000] Request to run job
0x6A98EE728DB2FC498C379735F3CE7567 (from Alert 11) refused
appears in our SQL Server Agent log. I'm try to track the source. So I'm
wondering what the hex value refer to and the bit "(from Alert 11)".
Thanks,
Tom
Hard to say, could you query select * from msdb.dbo.sysjobs where
jobid=0x6A98EE728DB2FC498C379735F3CE7567
to determine which job this id belongs to
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"T Morris" <TMorris@.discussions.microsoft.com> wrote in message
news:40AB8EB6-A0F7-40BF-93D3-ABBBB73F9706@.microsoft.com...
> The log entry
> 2006-09-19 21:16:06 - + [000] Request to run job
> 0x6A98EE728DB2FC498C379735F3CE7567 (from Alert 11) refused
> appears in our SQL Server Agent log. I'm try to track the source. So I'm
> wondering what the hex value refer to and the bit "(from Alert 11)".
> Thanks,
> Tom