Post reply

associatedObjectID = 72057594049462272

  • December 16, 2013 at 2:24 pm

    #283600

    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

    #1673880

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 16, 2013 at 3:19 pm

    #1673885

    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