Hi,
Please i want to disable lock escalation on a table.
Can somebody help me on how to do that?
thanks
Hi,
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
This might help you. Please have a look.
community.dynamics.com/.../manipulate-locking-on-table-indexes
i duplicated a standard table. ad i want to do it on that
Hi,
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?
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156