Applies to: SQL Server (all supported versions), Azure SQL Managed Instance Original KB number: 224453 Objective The article describes blocking in SQL Server and demonstrates how to troubleshoot and resolve blocking. In this article, the term connection refers to a single logged-on session of the database. Each connection appears as a session ID (SPID) or session_id in many DMVs. Each of these
![Understand and resolve blocking problems - SQL Server](https://cdn-ak-scissors.b.st-hatena.com/image/square/d6e4cb632c7025e9f5e05fd314fbf6dcd6144e8d/height=288;version=1;width=512/https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fmedia%2Fopen-graph-image.png)