Statistics Maintenance Review

Analyze stale SQL statistics, modification counters, plan risk, and maintenance-window recommendations for AX workloads.

rweisssieker-xp Updated

File contents

Statistics Maintenance Review

Use this skill when statistics_age.csv or stale-statistics findings are present.

Workflow

  1. Identify high modification ratios.
  2. Correlate stale statistics with top queries, Query Store, and plan variance.
  3. Recommend targeted statistics validation in an approved window.
  4. Measure before/after reads, CPU, duration, and plan stability.

Related Scripts

  • analyze_evidence.py
  • generate_validation_scripts.py
  • optimize_maintenance_window.py

rweisssieker-xp/ax2012_performance_advisory/tree/main/plugins/ax-performance-advisor-plugin/skills/statistics-maintenance-review commit 4244a133b1

Frequently asked questions

npx skillmds@latest add rweisssieker-xp/statistics-maintenance-review