Announcements
No record found.
Hi,
Please i want to disable lock escalation on a table.
Can somebody help me on how to do that?
thanks
I assume that you want to disable lock escalation on a standard table because it cannot be done using extensions. Can you give us more information about your situation? Have you analysed why you are getting locks?
i duplicated a standard table. ad i want to do it on that
This might help you. Please have a look.
community.dynamics.com/.../manipulate-locking-on-table-indexes
Although it's possible to disable lock escalation in SQL Server, we don't recommended it. Instead, use the prevention strategies.
If you want to disable lock escalation:
Table level: You can disable lock escalation at the table level via ALTER TABLE mytable SET(LOCK_ESCALATION=DISABLE).
See ALTER TABLE (Transact-SQL) - SQL Server | Microsoft Learn To determine which table to target, examine the T-SQL queries.
If that's not possible, use Quickstart: Extended Events in SQL Server - SQL Server | Microsoft Learn, enable the lock_escalation event, and examine the object_id column.
Alternatively use the Lock:Escalation Event Class - SQL Server | Microsoft Learn and examine the column by using SQL Profiler.
Best Regards,
Hana
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 658
André Arnaud de Cal... 468 Super User 2026 Season 1
Syed Haris Shah 333 Super User 2026 Season 1
