Content
100%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
This is an exceptionally well-crafted skill that serves as a model for SQL Server performance tuning guidance. It combines a structured diagnostic workflow with concrete, executable code examples and clear decision frameworks (temp tables vs table variables, parameter sniffing strategies ranked by preference). The progressive disclosure is excellent, keeping the main file focused on the diagnostic process and core patterns while pointing to detailed reference files for deeper dives.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | The content is dense with actionable information and avoids explaining concepts Claude already knows. Every section delivers specific SQL, concrete thresholds, or decision rules without padding. Comments in code are minimal and purposeful. | 3 / 3 |
Actionability | Fully executable T-SQL throughout — wait stats delta queries, missing index DMVs, covering index CREATE statements, parameter sniffing fixes with complete stored procedure examples. The SARGability table provides exact before/after rewrites. Everything is copy-paste ready. | 3 / 3 |
Workflow Clarity | The diagnostic flowchart is a clear 5-step sequence where each step narrows the cause before proceeding. Each step includes what to look for and what to do if the symptom is found, creating implicit feedback loops (e.g., 'fix statistics so the grant is sized correctly' then re-evaluate). The ranked parameter sniffing strategies provide explicit ordering. | 3 / 3 |
Progressive Disclosure | The SKILL.md provides a comprehensive but focused overview with well-signaled one-level-deep references to six specific reference files (execution-plans.md, index-strategy.md, wait-stats.md, locking-blocking.md, batch-operations.md, statistics-tuning.md). References are contextually placed where relevant and also collected in a final Reference Files section for discovery. | 3 / 3 |
Total | 12 / 12 Passed |