Share via

Monitor Lock escalation in Azure SQL

Marios Pavlidis 51 Reputation points
2022-05-31T13:15:57.78+00:00

Hi,

Is there a way to monitor Lock escalation in Azure SQL. It seems that the lock_escalation Extended Event is missing!

Best regards,
Marios Pavlidis

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    2022-05-31T18:36:52.487+00:00

    Hi, @Marios Pavlidis Welcome to Microsoft Q&A, Thanks for posting your query.
    As we understand you want to if there is a way to monitor Lock escalation in Azure SQL
    Right now the only way is to periodically poll sys.dm_tran_locks looking for object-level locks. This doesn’t tell if such a lock is the result of lock escalation specifically, but for monitoring purposes, this may be sufficient.

    I will check with the Internal product team on why this event isn’t available in SQL DB.

    Regards
    Geetha

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.