Lock-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