Tagged articles

lock-escalation

3 articles · Page 1 of 1

Programmer1970

May 31, 2026 · Fundamentals

Why synchronized is slower – tracing its roots from MESI cache coherence

The article demystifies why Java's synchronized keyword can be slower by tracing the full path from CPU cache‑coherence (MESI) through bus and cache locks, volatile, biased and lightweight locks, up to the heavyweight monitor implementation, revealing each layer’s impact on visibility, ordering and atomicity.

JVMVolatilecache-coherence

0 likes · 15 min read

Why synchronized is slower – tracing its roots from MESI cache coherence

Architecture Digest

Sep 5, 2020 · Databases

Understanding SQL Server Lock Escalation and How to Prevent It

This article explains the fundamentals of SQL Server locking, illustrates how row‑level locks can automatically escalate to table‑level locks during large batch operations, and provides practical techniques—such as batching deletes, adding appropriate indexes, and holding intent locks—to avoid lock escalation and improve concurrency.

Database LocksSQLSQL Server

0 likes · 12 min read

Understanding SQL Server Lock Escalation and How to Prevent It

Programmer DD

Aug 31, 2020 · Databases

Why Does My Delete Script Lock the Whole Table? Understanding SQL Server Lock Escalation

This article explains how massive delete operations can cause row locks to be promoted to table locks in SQL Server, why this leads to blocking and errors, and provides practical techniques such as batching, indexing, and intent locks to prevent lock escalation and keep databases responsive.

Database LocksSQL ServerTransaction Management

0 likes · 12 min read

Why Does My Delete Script Lock the Whole Table? Understanding SQL Server Lock Escalation