execution plans skills

26 tagged execution plans, measured the same way as everything else here.

Browse within: database-tuning 26extended-events 26index-tuning 26performance-tuning 26

vanterx/mssql-performance-skills

Skill Claude CodeCodex

Analyze SQL Server encryption posture across all layers — TDE, Always Encrypted, cell-level encryption, backup encryption, transport/TLS, certificate lifecycle, asymmetric and symmetric key management, DMK/SMK key hierarchy including spcontroldbmasterkeypassword and SSISDB, EKM/AKV, sensitivity-classification gaps…

5 1mo ago A 279 tokens original MIT

sqlplan-review

02

vanterx/mssql-performance-skills

Skill Claude CodeCodex

Analyze SQL Server execution plans for performance anti-patterns, bottleneck identification, and actionable fix recommendations. Applies 111 checks (S1–S38 statement-level, N1–N73 node-level) covering memory grants, parallelism, cardinality errors, spills, scans, index usage, IQP/PSP features, ADR, CE feedback, hidden…

5 1mo ago A 195 tokens original MIT

sqlwait-review

03

vanterx/mssql-performance-skills

Skill Claude CodeCodex

Analyze SQL Server wait statistics to identify why the server or a session is slow. Applies 44 checks (V1–V44) 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…

5 1mo ago A 174 tokens original MIT