Post reply

Identifying KEY Resource in Deadlock

  • August 2, 2007 at 8:12 am

    #179962

    I have a 5-7 node, recurring deadlock issue. One node identifys a key for its resource. When I look in database 8, there is no object with this ID. Any idea what this key might translate to?

    KEY: 8:72057595568062464 (00005351d7ca) CleanCnt:2 Mode:U Flags: 0x0

    Thanks in advance.

    Terry

     

     

  • August 2, 2007 at 12:35 pm

    #724298

    I have no idea.  And since SPIDs and object_IDs can vary per database, I'm not sure you'll be able to get an answer for that.

    But running profiler during the deadlock should get you at least the queries that are killing each other.  Maybe then you can identify each of the objects used in those queries to find out which one isn't existing on the database in question?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply