SQL Server Concurrency: Locking, Blocking, and Row Versioning

Condition - Very Good
The item shows wear from consistent use, but it remains in good condition and functions properly. Item may arrive with damaged packaging or be repackaged. It may be marked, have identifying markings on it, or have minor cosmetic damage. It may also be missing some parts/accessories or bundled items.

SQL Server Concurrency: Locking, Blocking, and Row Versioning

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.

You might also like...