Parameter Sniffing Analysis
Use this skill when plan count, runtime variance, or Query Store evidence suggests unstable plans.
Workflow
- Run
scripts/watch_plan_regressions.py. - Review
plan_cache_variance.csvandquery_store_runtime.csv. - Compare query family, object, module, and business window.
- Recommend plan capture and TEST validation before any forcing or code change.
Related Scripts
watch_plan_regressions.pyanalyze_query_families.pyparse_plan_xml.py