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 […]
Tag: lock-escalation
SQL Server Lock Escalation clarity required
Question : I want to know whether Enabling the Trace Flag 1211 globally prevents the Lock Escalation even in the […]
Does SQL Server upgrade to table locks at total locks or session locks?
Question : I’ve a table that both has mass sequential inserts at the end of the CI and random (very […]
Why isn’t partition-level lock escalation the default?
Question : In SQL Server, locks are normally escalated from row or page -> table. Starting with SQL Server 2008, […]
Indexes with High Lock waits – how to fix
Question : I’ve been running dbo.sp_BlitzIndex and have 4 somewhat similar indexes on the main table in my database. Each […]
Risk of disabling page locking
Question : In another question a user asks how to force row level locking. The answer that he receives tell […]