© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_18

18. Troubleshooting Blocking Issues

Dmitri Korotkevitch

(1)Tampa, Florida, USA

Blocking is one of the most common problems encountered in systems. When blocking occurs, multiple queries block each other, which increases the execution time of queries and introduces timeouts. All of this negatively affects the user’s experience with the system.

This chapter provides an overview of how you can troubleshoot blocking issues in a system.

General Troubleshooting Approach

Blocking occurs when multiple sessions compete for the same resource. Even though in some cases this is the correct and expected behavior (for example, multiple sessions cannot update the ...

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.