SQL Server Concurrency: Locking, Blocking, and Row Versioning

by Kalen Delaney

Multiple processes often access the same data at the same time, so SQL Server has to make one process wait, sacrificing concurrency and performance.This book explores how SQL Server uses locks to avoid concurrency problems, and advice on the to control locking with hints and bound connections. It also walks you through how row versioning works, and how to troubleshoot excessive blocking and deadlocking.

202 pages, Kindle Edition

First published May 23, 2013

Reviews

[John Deardurff · Rating 5 out of 5]

Another of the free books from Redgate, this one dealing with SQL Server Concurrency issues. https://www.red-gate.com/hub/books/ This is a straight forward look at Locks, Blocks, and Deadlocks. Along with Transactions and Isolation Levels. Another excellent foundational book for any SQL Server DBA to help improve query performance.