analyze_parameter_sniffing
Detect parameter sniffing by identifying queries with multiple compiled plans and widely varying runtimes, ranked by slowest-to-fastest plan ratio.
Instructions
Detect queries whose runtime varies widely across multiple compiled plans — the classic parameter-sniffing signature. Ranks by the ratio of slowest to fastest plan mean duration.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"database_name": "<database_name>"
},
"name": "analyze_parameter_sniffing"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | Max rows to return. | |
| database_name | Yes | Target SQL Server database name. | |
| min_plan_count | No | Minimum distinct plans for a query to be considered (2 = at least two plans). |