collect_performance_evidence
Collects Azure SQL resource, Query Store, wait, blocking, statistics, parameter-sensitivity, and regression evidence to diagnose performance case root causes.
Instructions
Collect Azure SQL resource, Query Store, wait, blocking, statistics, parameter-sensitivity, and regression evidence for a performance case.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | The same baseline SQL used to create the case. | |
| case_id | Yes | Performance case identifier. | |
| decision_id | No | ||
| database_name | No | ||
| execute_query | No | Capture one actual-plan sample. Requires database benchmark policy. | |
| parameter_case | No | For active evidence on parameterized SQL, one named case containing an exact values object and exact SQL types object. | |
| window_minutes | No | ||
| idempotency_key | No | ||
| query_store_query_id | No | Optional exact Query Store query_id. It must match any identity already stored on the performance case. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||