Announcements
No record found.
Hi,
I just disabled page and lock escalation for a table. How long will this be kept and is there any way to find out the history of the lock escalation so we know which tables have been disabled lock escalation?
Thanks,
It's kept forever. But if you replace the database with a copy from another system, I believe that the changes in your original database are lost. Because you chose to replace it with a new one.
You can see the environment history in LCS to see which tables have been disabled for lock escalation.
This is mentioned in the documentation: docs.microsoft.com/.../performancetroubleshooting
Hi Yuji,
Lock escalation will be disabled until you will not decide to enable it back.
Page locks are related to indexes and a new index or index change for a table will break this setup and you will need to disable page locks again.
Recently for PROD environment watchdog was added to monitor indexes changes and if you disable page locks before, the watchdog will disable page locks for new\changed indexes as well.
For the sandbox environment, you still need to do it manually (or copy the database from PROD if possible).
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
