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