lock-escalation Archives

Lock Escalation and Count Discrepancy in lock_acquired Extended Event

By adminPosted on April 13, 2022

Question : I’m trying to understand why there is a discrepancy in lock count in sys.dm_tran_locks and sqlserver.lock_acquired extended event […]

By adminPosted on February 12, 2022

Question : I want to know whether Enabling the Trace Flag 1211 globally prevents the Lock Escalation even in the […]

By adminPosted on October 23, 2021

Question : I’ve a table that both has mass sequential inserts at the end of the CI and random (very […]

By adminPosted on October 14, 2021

Question : In SQL Server, locks are normally escalated from row or page -> table. Starting with SQL Server 2008, […]

By adminPosted on December 31, 2020

Question : I’ve been running dbo.sp_BlitzIndex and have 4 somewhat similar indexes on the main table in my database. Each […]

By adminPosted on April 26, 2020

Question : In another question a user asks how to force row level locking. The answer that he receives tell […]