detect_parameter_sniffing
Identify parameter sniffing by comparing query plan durations; flags queries where the worst-to-best ratio exceeds a threshold (default 10x).
Instructions
Detect parameter sniffing: queries with multiple plans where MAX(avg_duration) / MIN(avg_duration) exceeds threshold (default 10x).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | Max number of results. | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. | |
| window_minutes | No | Query Store lookback window in minutes (default 24 hours). | |
| variance_threshold | No | Min ratio of worst/best plan duration to flag (e.g., 10 = 10x worse). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||