Editorial question123.1K views3,436 votes0 answers4,838 following
AI-generatedLock-request timeouts under concurrent DML: SQL Server Database Engine lock escalation
Lock escalation in the SQL Server Database Engine converts many row or page locks into a single table-level lock, a documented behavior that can increase blocking and latency when concurrent sessions access the same table. The exact lock count or memory threshold that triggers escalation is not published as a fixed constant and can vary by SQL Server version
microsoftsqlserver