Blocking is, perhaps, one of the most common concurrency problems encountered in the systems. When blocking occurs, multiple queries block each other, which increases the execution time of queries and introduces timeouts. All of that negatively affects the user experience with the system.
This chapter will show how you can troubleshoot blocking issues in a system. It will illustrate how you can analyze blocking conditions in real time and collect information for further analysis.
General Troubleshooting Approach
Blocking occurs when multiple ...
