Author: SSWUG Research

Community

Lock Escalations

(Klaus Aschenbrenner) In todays blog posting I want to talk about Lock Escalations in SQL Server. Lock Escalations are an optimization technique used by SQL Server to control the amount of locks that are held within the Lock Manager of SQL Server.