sqlplan-compare

Community

Diff two SQL plans to find regression causes.

Authorvanterx
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Compares two SQL Server execution plans for the same query to identify exactly what changed and caused a performance regression.

Core Features & Use Cases

  • Side-by-side plan comparison highlighting differences in join strategies, memory grants, operator topology, spills, and missing indexes.
  • Surface actionable findings with a prioritized fix list for quick remediation.
  • Ideal when a deployment, statistics update, or schema change regresses query performance.

Quick Start

Provide two SQL Plan files (baseline.sqlplan and new.sqlplan) to generate a diagnostic delta report.

Dependency Matrix

Required Modules

None required

Components

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: sqlplan-compare
Download link: https://github.com/vanterx/mssql-performance-skills/archive/main.zip#sqlplan-compare

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.