Resolving blocking problems that are caused by lock escalation in SQL Server

Lock escalation is the process of converting many fine-grained locks (such as row or page locks) into table locks. Microsoft SQL Server dynamically determines when to perform lock escalation. When making this decision, SQL Server takes into account the number of locks that are held on a particular s

Read More - Register for Free Membership