get_query_wait_stats
Retrieve per-query wait stats from Query Store to diagnose slow queries. Identify which wait types affect each query, revealing the exact reason for performance issues.
Instructions
Get per-query wait breakdown from Query Store wait stats. Ties waits to specific queries: 'this query is slow because of X'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | Number of top results. | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. | |
| window_minutes | No | Query Store lookback window in minutes. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||