procstats-review

Analyze SQL Server runtime statistics from DMVs to surface performance insights.

5|Updated May 2, 2026

Search Tags:#performance #analyze #sql-server #trend-analysis #proc-stats #dmv #dba-tools

Ready to run

npx skills add https://github.com/vanterx/mssql-performance-skills --skill procstats-review

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: procstats-review
Source: https://github.com/vanterx/mssql-performance-skills/tree/main/skills/procstats-review
Command: npx skills add https://github.com/vanterx/mssql-performance-skills --skill procstats-review

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about procstats-review

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I analyze SQL Server runtime statistics to find performance bottlenecks?▼

Analyzing SQL Server runtime statistics requires examining dynamic management views like sys.dm_exec_procedure_stats to surface expensive procedures, triggers, and functions. This Skill processes Q1–Q5 report outputs to apply 20 checks across resource consumption and efficiency categories.

What SQL Server DMVs do I need to collect procedure stats for tuning?▼

SQL Server procedure stats tuning relies on sys.dm_exec_procedure_stats, sys.dm_exec_trigger_stats, and sys.dm_exec_function_stats. You must collect outputs from the sql/collection/04_report_queries.sql script covering Q1–Q5 reports before running the analysis.

How do I identify top resource consuming stored procedures in SQL Server?▼

Identifying top resource consuming stored procedures involves checking runtime stats from dynamic management views for high CPU or logical reads. This Skill applies pattern detection and per-execution efficiency checks to prioritize tuning efforts for the most expensive procedures.

Can I use this analysis for SQL Server triggers and functions, not just stored procedures?▼

Yes, this analysis works for SQL Server triggers and functions alongside stored procedures. It evaluates runtime statistics from sys.dm_exec_trigger_stats and sys.dm_exec_function_stats to generate remediation guidance for plan stability and workload management across all three object types.

What is the best way to prioritize SQL Server performance tuning efforts?▼

Prioritizing SQL Server performance tuning efforts requires structured findings based on runtime stats across four categories: top resource consumers, per-execution efficiency, pattern detection, and trend analysis. This approach generates actionable remediation guidance to optimize plan stability.

How do I detect performance trends in SQL Server procedure execution stats?▼

Detecting performance trends in SQL Server procedure execution stats involves analyzing runtime data from dynamic management views over time. This Skill applies trend analysis checks alongside pattern detection to surface actionable insights and guide ongoing workload monitoring.