ClaudSkills / Science & Research / math-stats

Sqlwait Review

Category: Science & Research  ·  Sub-category: math-stats
type:review
Analyze SQL Server wait statistics to identify why the server or a session is slow. Applies 40 checks (V1–V40) covering I/O, locks, parallelism, memory, CPU, TempDB, log I/O, network, latch contention, log space exhaustion, poison/throttle waits, backup I/O, insert hotspots, cumulative skew detection, multi-snapshot trend analysis, In-Memory OLTP, Columnstore, Query Store, Transaction/DTC, Service Broker, Full Text Search, Parallel Redo, forced memory grants, grant timeouts, stolen memory, and file I/O latency. Based on Paul Randal and Brent Ozar methodologies. Use when pasting sys.dm_os_wait_stats or sys.dm_exec_requests output.

What this skill does

Sqlwait Review is a community-contributed Claude Code skill in the math-stats sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/sqlwait-review/ and loads when your prompt matches the skill's trigger.

When to invoke it: Use when pasting sys.dm_os_wait_stats or sys.

Who uses this skill

The Sqlwait Review skill is built for researchers, data scientists, academics, and analysts working with complex data and scientific literature. It is part of the open ClaudSkills registry, a community-curated catalog of 56,000+ capabilities you can install for Claude Code — the Claude CLI agent.

How to install

Free

Manual install (2 steps)

mkdir -p ~/.claude/skills/sqlwait-review
curl -L https://claudskills.com/skills/sqlwait-review/SKILL.md \
  -o ~/.claude/skills/sqlwait-review/SKILL.md

Or just download SKILL.md directly and drop it into ~/.claude/skills/sqlwait-review/. Claude Code auto-discovers it on next session.

Skills live at ~/.claude/skills/sqlwait-review/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\sqlwait-review\SKILL.md on Windows. See the full install guide for step-by-step instructions.

Pro

One-click install via the desktop app

The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.

Pro

For the full experience including quality scoring and one-click install features for each skill — upgrade to Pro.

More Science & Research skills

Browse all Science & Research skills in the ClaudSkills registry, or explore these other picks from the same category:

Browse all Science & Research skills → Top 100 skills
Part of ClaudSkills — the open registry for Claude Code skills.  ·  What's New  ·  Install guide  ·  About  ·  llms.txt

Part of Acreator Store — Adam Lankamer's AI tools: GifPerfect · AspectPerfect · SlomoPerfect · Ucaption · UTagger · AutoXPoster · TestYourSkills