I'm sure I asked this question on here before and pretty sure I got a very
useful answer to my question, however, being the dufus I am I didn't save
the answer and have long since forgotten what it was. So here I am again,
encamped upon your floor to ask once more what is the Associated ObjectaID
that gets displayed in the deadlock graph because it sure doesn't seem to be
an object_id from sys.objects?

Can anyone please explain to this forgetful old DBA?

An example of an associated object id would be like 72057647487385600.

Thanks,

Michael MacGregor
Database Architect

Whilst I am on the subject? Is there a really good book, or article that
fully explains the deadlock graph because so far neither BOL nor anything
else I can find online does a satisfactory job of it.

TIA

MTM

That's the HoBt ID. (HoBt stands for "Heap or B-tree.") In SQL Server 2005
and 2008 the HoBt ID is identical to the partition_id. So, you can say:

SELECT OBJECT_NAME([object_id])
FROM sys.partitions
WHERE partition_id = 72057647487385600;

If you use non-dbo schemas then it is safer to say (assuming 2005 P2 or
higher):

SELECT OBJECT_SCHEMA_NAME([object_id]),
OBJECT_NAME([object_id])
FROM sys.partitions
WHERE partition_id = 72057647487385600;

As for your follow-up question, Grant Fritchey does a great job demystifying
deadlock graph analysis in "SQL Server 2008 Query Performance Tuning
Distilled." (ISBN = 978-1-4302-1902-6)

Don't be scared by the version in the title; most of the concepts in the
book apply equally to 2005. Since you are looking at sys.objects I assume
you are not concerned about SQL 2000, but it never hurts to mention which
version(s) you are managing.

A





On 6/15/09 12:59 PM, in article #NgSkqd7JHA.240 (AT) TK2MSFTNGP03 (DOT) phx.gbl,
"Michael MacGregor" <macnoknifespam (AT) noemailspam (DOT) com> wrote:

This may be a useful primer also...

http://is.gd/12HnD


On 6/15/09 1:17 PM, in article #U2s00d7JHA.3860 (AT) TK2MSFTNGP05 (DOT) phx.gbl,
"Michael MacGregor" <macnoknifespam (AT) noemailspam (DOT) com> wrote:

Michael MacGregor (macnoknifespam (AT) noemailspam (DOT) com) writes:
Personally I have found little value of the deadlock graph in Profiler.
You get more information if you enable traceflag 1222.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Where would be the best place to find detailed information about that
traceflag?

MTM

Thanks Aaron.

MTM

Thanks, but I wasn't asking about the HoBt ID, I was asking about the
associated objid that appears in the Resource Node box. According to that
article by Brad McGehee you gave me a link to it's "...the object ID of the
table associated with this index." This would appear to be incorrect as that
ID most definitely does not exist in the sys.objects table.

MTM

Yes I didn't read the article verbatim. But I believe I answered your
question already... The "object ID" is actually the HoBt ID, which (at least
in current versions 2005/2008) corresponds to partition_id in
sys.partitions...


On 6/16/09 11:13 AM, in article eZNn8Tp7JHA.4116 (AT) TK2MSFTNGP04 (DOT) phx.gbl,
"Michael MacGregor" <macnoknifespam (AT) noemailspam (DOT) com> wrote:

http://blogs.msdn.com/bartd/archive/...09/747119.aspx




On 6/16/09 11:09 AM, in article #mF3mRp7JHA.1764 (AT) TK2MSFTNGP06 (DOT) phx.gbl,
"Michael MacGregor" <macnoknifespam (AT) noemailspam (DOT) com> wrote: