Post reply

Lock escalation

  • July 22, 2016 at 8:27 am

    #328324

    Hi,

    Is there any way to find if there is any lock escalation?

    Regards,

  • July 22, 2016 at 8:32 am

    #1891587

    Yes. Capture the lock_escalation event in an Extended Events session.

    John

  • July 22, 2016 at 7:02 pm

    #1891683

    John Mitchell-245523 (7/22/2016)

    Yes. Capture the lock_escalation event in an Extended Events session.

    John

    Thanks, but how I can use SQL query to get this from Extended Events. The reason why I ask is that I need to develop an application to detect this in .NET.

  • July 22, 2016 at 7:08 pm

    #1891684

    And also, can I use performance counter "SQLServer:Access Methods - Table Lock Escalations/sec" as well?

  • July 23, 2016 at 4:20 am

    #1891695

    You can write the extended event session to a ring buffer, that's queryable. The perfmon counter will work as well if you just want a count.

    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

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

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