Statistics Maintenance Review

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

rweisssieker-xp Updated 1 repo stars

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 commit 4244a133b1

Frequently asked questions

npx get-skill add rweisssieker-xp/statistics-maintenance-review