skills.rest
vanterx
vanterxCOMMUNITY
Explore all skills by this author →
GitHub

sqlwait-review

Analyze SQL Server wait statistics to identify dominant bottlenecks and remediation steps.

5|Updated May 2, 2026
Search Tags:#diagnostics#sql-server#trend-analysis#performance-analysis#wait-stats#waits-and-queues
One-click install
npx skills add https://github.com/vanterx/mssql-performance-skills --skill sqlwait-review
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlwait-review
Source: https://github.com/vanterx/mssql-performance-skills/tree/main/skills/sqlwait-review
Command: npx skills add https://github.com/vanterx/mssql-performance-skills --skill sqlwait-review

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyze wait statistics to identify the dominant bottleneck in SQL Server workloads.

Core Features & Use Cases

  • Applies 40 checks (V1–V40) to classify waits (I/O, locks, parallelism, memory, CPU, TempDB, log I/O, network, latch contention, and more) and produce a prioritized remediation plan.
  • Supports single-snapshot and multi-snapshot trend analysis to detect spikes, trends, and correlated waits.
  • Integrates with common DMVs (sys.dm_os_wait_stats, sys.dm_exec_requests) and optional Query Store patterns to guide tuning efforts.

Quick Start

Paste the wait statistics output (sys.dm_os_wait_stats or sys.dm_exec_requests) to begin analysis and receive a bottleneck-focused report.

Frequently Asked Questions about sqlwait-review

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

FAQPage Schema
How do I analyze SQL Server wait statistics to identify performance bottlenecks?▼

Analyzing SQL Server wait statistics involves querying DMVs like sys.dm_os_wait_stats to classify waits into categories such as I/O, locks, memory, and CPU. This Skill applies 40 structured checks to surface the dominant bottleneck and generate a prioritized remediation plan.

What is the best way to find the root cause of SQL Server locks and latch contention?▼

To find SQL Server lock and latch contention, you evaluate wait statistics across single or multiple capture windows. Categorizing these waits helps correlate spikes and trends, pinpointing specific resource contention for targeted tuning.

Can I use this wait stats analysis with Query Store patterns and active requests?▼

Yes, the analysis integrates with common DMVs including sys.dm_os_wait_stats and sys.dm_exec_requests, alongside optional Query Store patterns. This combination guides query tuning efforts by mapping categorized waits to specific query behaviors.

Does SQL Server wait statistics analysis support multi-snapshot trend detection?▼

Yes, wait statistics analysis supports multi-snapshot trend detection. By comparing multiple capture windows, you can detect correlated waits, identify performance spikes over time, and distinguish transient issues from persistent bottlenecks.

Related Skills

Explore More Data & Analytics Skills→
chrishuffman5chrishuffman5

sqlserver-monitoring

Monitor and diagnose SQL Server performance using DMVs, Extended Events, and Query Store.

Community
Advanced
halim-23halim-23
1

odoo-performance

Identify and fix Odoo performance bottlenecks with optimization techniques for versions 17/18/19.

Community
Advanced
claudcherejiclaudchereji

database-optimizer

Analyze query execution plans and design index strategies across multiple database systems.

Community
Advanced
interflownexinterflownex
2

cloud-sql-postgres-health

Diagnose query bottlenecks and resource constraints in Google Cloud SQL for PostgreSQL instances.

Community
Advanced