mssql_find_blocking
Find current blocking chains in SQL Server: identifies blocked sessions, lead blockers (including idle sessions with open transactions), resources, duration, and SQL text. Requires VIEW SERVER STATE.
Instructions
Find current blocking chains: which sessions are blocked, by whom, on what resource, and for how long. Identifies lead blockers (including idle sessions holding open transactions) with their SQL text. Supported: SQL Server 2019 (15.x), 2022 (16.x), 2025 (17.x) — all editions including Express. Requires VIEW SERVER STATE.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| response_format | No | Response format (default: markdown) | markdown |