March 10, 2011 at 12:28 am
Hello
The deadlock graph details about the key, page, table involved in deadlock.
In my deadlock graph, there is KEY: 7:72057594863222784 (ac01d9cdfaec)
where 72057594863222784 is hobt_id (as according to BOL)
In Sql 2005 hobt_id and partition_id are same, so i should be getting the object id/name querying syspartition.
Strangely, though i do not ger any row ..!! (yes, i'm querying on right database)
What can be the reason for this.
The database, is not restored.
SQL SERVER 2005 SP3
Query i use:
SELECT hobt_id, object_name(p.[object_id]), index_id FROM sys.partitions p
WHERE hobt_id = 72057594863222784
February 24, 2012 at 3:24 pm
It has LRU'd out of memory cache. That's why you cannot find it anymore.
February 24, 2012 at 4:07 pm
Are you absolutely sure you're running the query in the same database? (database 7)
It's not an issue of aging out of memory, the partitions aren't plans, they're persisted objects.
Could a table or index have been dropped since that deadlock?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply