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 ...