procstats-review

What problem does it solve?

Identify performance bottlenecks in SQL Server by analyzing runtime statistics collected from dynamic management views, enabling DBAs to quickly locate expensive procedures, triggers, and functions.

Core Features & Use Cases

• Applies 20 checks (R1–R20) across four categories (top resource consumers, per-execution efficiency, pattern detection, and trend analysis) to surface actionable insights from runtime stats.
• Supports inputs from Q1–Q5 report outputs, allowing rapid prioritization of tuning efforts for procedures, triggers, and functions.
• Produces structured findings and remediation guidance to guide optimization, plan stability, and workload management across ongoing performance monitoring.

Quick Start

Paste Q1–Q5 outputs from sql/collection/04_report_queries.sql into this Skill to run all checks and generate findings.