Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
