Deadlock Object ID

[bwilkinson]

I have a deadlock message that I am having a little trouble decipering.

the DBID I have converted to the correct DB using sys.objects with no problem but the Object ID and Index ID I can not figure out how to find the actual objects in my DB.

107 Index (Key) dbid: 6, object id: 72057598122328064, index id: (a603eec0617a) UPDATE Line #: 565

Any help would be great .

-Brian

[Brian Donahue]

Hi Brian,

You can resolve the object ID to an object name using
SELECT object_name(72057598122328064)

I hope this helps!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[bwilkinson]

When I try that I get the following error message

Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.

[Brian Donahue]

Hi Brian,
It looks like SQL Server has a bug. Please see this Microsoft article for a workaround.

http://connect.microsoft.com/SQLServer/feedback/details/276695/certain-dmvs-causing-arithmetic-overflow-during-deadlock
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[kevriley]

That id looks more like the bigint field partition_id or hobt_id that you find in sys.partitions.

Try ...

select * from sys.partitions where partition_id = '72057598122328064'

or
select * from sys.partitions where hobt_id = '72057598122328064'

this will then give you an object_id (int) that can be used with Object_name() to resolve