get_deadlock_history
Retrieve recent deadlock history from Azure SQL system_health session. Parses deadlock XML to identify victim, participants, resources, and SQL text for troubleshooting.
Instructions
Get recent deadlock history from system_health extended events session. Parses deadlock XML to show victim, participants, resources, and SQL text.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max_events | No | Maximum number of deadlock events to return. | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||