December 16, 2013 at 2:24 pm
Hello,
I keep seeing blocking with associatedObjectID = 72057594049462272 which doesn't exist in the specified database or any other database on that instance. It is not a temp table as the id is always coming back the same.
This ID shows up in a google for:
In this scenario, deadlocks may occur on the query notification system tables (for example, a system table with a name that resembles sys.query_notification_xxxxxx). Additionally, the following deadlock graph is logged in the SQL Server error log file:
http://support.microsoft.com/kb/975090
We are not using Service Broker.
Any suggestions. It is repeated pattern of blocking occurring.
Thanks,
Daniel
December 16, 2013 at 3:00 pm
It's an allocation unit ID, not an object ID. Query sys.partitions.
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
December 16, 2013 at 3:19 pm
thanks, found the object now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply