# Parameter Sniffing Analysis

> Analyze plan-cache variance, Query Store runtime variation, and parameter-sensitive AX query candidates.

- Skill: `rweisssieker-xp/parameter-sniffing-analysis` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/parameter-sniffing-analysis`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/parameter-sniffing-analysis/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/parameter-sniffing-analysis

---


# Parameter Sniffing Analysis

Use this skill when plan count, runtime variance, or Query Store evidence suggests unstable plans.

## Workflow

1. Run `scripts/watch_plan_regressions.py`.
2. Review `plan_cache_variance.csv` and `query_store_runtime.csv`.
3. Compare query family, object, module, and business window.
4. Recommend plan capture and TEST validation before any forcing or code change.

## Related Scripts

- `watch_plan_regressions.py`
- `analyze_query_families.py`
- `parse_plan_xml.py`