Post reply

Decoding the keys for LCK_M_X wait type

  • November 11, 2011 at 1:34 pm

    #251712

    Hi all.

    I am seeing a lot of wait types with wait resource as

    KEY: 10:72057594038714368 (01009eb309ad)

    KEY: 10:72057594038714368 (01002bd6f0da)

    KEY: 10:72057594038714368 (01002bd6f0da)

    KEY: 10:72057594038714368 (01002bd6f0da)

    KEY: 10:72057594038714368 (01002bd6f0da)

    KEY: 10:72057594038714368 (0100c4996f5b)

    KEY: 10:72057594038714368 (01003e9725df)

    how can i decode this. I want to know the name of the object.

    Thanks for your help in advance

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • November 11, 2011 at 1:53 pm

    #1406588

    I used the script below to identify the name of the object. But all I see is nothing in the output. Do I need to enable a trace flag for this

    SELECT o.name, i.name

    FROM sys.partitions p

    JOIN sys.objects o ON p.object_id = o.object_id

    JOIN sys.indexes i ON p.object_id = i.object_id

    AND p.index_id = i.index_id

    WHERE p.hobt_id='72057594038714368'

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • November 11, 2011 at 2:21 pm

    #1406598

    That script's correct. Just make sure you're in database 10 when you run it.

    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

  • November 11, 2011 at 2:44 pm

    #1406604

    Yep..that works..I was on a different database. Thanks Gail.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Viewing 4 posts - 1 through 3 (of 3 total)

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