Troubleshooting Blocking Issues
Blocking is perhaps 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 query timeouts. All of that negatively affects the user experience with the system.
This chapter provides an overview 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 a same row simultaneously) ...