sqlwait-review
CommunityPinpoint SQL Server bottlenecks by analyzing wait statistics.
Data & Analytics#diagnostics#sql-server#trend-analysis#performance-analysis#wait-stats#waits-and-queues
Authorvanterx
Version1.0.0
Installs0
System Documentation
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.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sqlwait-review Download link: https://github.com/vanterx/mssql-performance-skills/archive/main.zip#sqlwait-review Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.