26 tagged database tuning, measured the same way as everything else here.
Browse within: execution-plans 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…
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…
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…