# Sqlserver Review

> Review SQL Server schemas, queries, and configuration for performance and production readiness

- Skill: `erp-core-dev/sqlserver-review` (Agent Skill)
- Install (CLI): `npx skillmds@latest add erp-core-dev/sqlserver-review`
- Raw SKILL.md: https://api.skillmd.com/api/skills/erp-core-dev/sqlserver-review/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ERP-CORE-DEV (https://skillmd.com/u/erp-core-dev)
- Updated: 2026-09-10
- Page: https://skillmd.com/skills/erp-core-dev/sqlserver-review

---


# SQL Server Review

Review SQL Server for execution plans, index tuning, tempdb, Always On AG, Query Store, and security.

## Key Checks
- Actual execution plans — flag Key Lookup, Hash Match spills, Implicit Conversion warnings
- Clustered index: narrow, unique, ever-increasing; nonclustered columnstore for analytics
- sys.dm_db_missing_index_details hints, dm_db_index_usage_stats for unused indexes
- tempdb: multiple data files (up to 8), pre-sized to avoid auto-growth
- Always On: synchronous-commit same DC only, async for cross-region
- Query Store enabled, regressed query identification, plan forcing for parameter sniffing
- Parameter sniffing: OPTION (OPTIMIZE FOR UNKNOWN) or statement-level RECOMPILE
- AUTO_UPDATE_STATISTICS ON, FULLSCAN after large data loads
- DMV monitoring: dm_exec_requests, dm_os_wait_stats, dm_io_virtual_file_stats
- sa disabled, TRUSTWORTHY OFF, Always Encrypted for PII columns

## Output
Severity-sorted: CRITICAL, HIGH, MEDIUM, LOW, PASSED.