Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Disable lock escalation

(0) ShareShare
ReportReport
Posted on by 6

Hi,

Please i want to disable lock escalation on a table.

Can somebody help me on how to do that?

thanks

  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Disable lock escalation
    Hi,
    We haven't heard from you for a long time. Has your issue been resolved? If so, please mark the issue as verified.  Thanks a lot!
    Best Regards,
    Hana

     
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    RE: Disable lock escalation

    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

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    RE: Disable lock escalation

    This might help you. Please have a look.

    community.dynamics.com/.../manipulate-locking-on-table-indexes

  • foaghana1 Profile Picture
    foaghana1 6 on at
    RE: Disable lock escalation

    i duplicated a standard table. ad i want to do it on that

  • Anton Venter Profile Picture
    Anton Venter 19,493 Super User 2025 Season 1 on at
    RE: Disable lock escalation

    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?

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans