get_open_transactions
List open transactions in an Azure SQL database with duration, transaction type, log bytes used, and warnings for long-running or idle-in-transaction to identify blocking issues.
Instructions
Get open transactions with duration, type (read/write, read-only), log bytes used, and warnings for long-running or idle-in-transaction.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum transactions to return (oldest first, max 1000). | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||