sqlag-reviewlisted

Audits SQL Server Always On Availability Group configuration correctness across all layers — prerequisites, replica design, listener architecture, backup strategy, endpoint security, distributed AG topology, Basic and Contained AG constraints, and application integration readiness. Use this skill when setting up a new AG, reviewing an existing AG design before a DR test, preparing for a failover, or investigating connection failures, listener misconfigurations, backup failures on secondaries, or endpoint certificate expiry. Applies 37 checks (F1–F37) across 7 categories. Trigger for questions about AG prerequisites, session timeout, failure condition level, read-only routing configuration, MultiSubnetFailover, backup preferred replica, distributed AG setup, Basic AG limits, Contained AG, endpoint encryption, or automatic seeding mode during a manual-restore workflow. Companion to /sqlhadr-review (runtime health) and /sqlclusterlog-review (WSFC events).
vanterx/mssql-performance-skills · ★ 5 · API & Backend · score 77

Install: claude install-skill vanterx/mssql-performance-skills

# SQL Server Always On AG Configuration Review Skill ## Purpose Audit the configuration and design of one or more SQL Server Always On Availability Groups. Applies 37 checks (F1–F37) across seven categories: - **F1–F6** — Prerequisites and instance setup: AlwaysOn feature, database recovery model, endpoint state, endpoint encryption, failure condition level, version alignment across replicas - **F7–F13** — Replica configuration design: synchronous replica count, WAN session timeout, health check timeout, backup priority ties, replica join state, database join completeness, readable secondary availability - **F14–F18** — Listener and network design: multi-subnet IP completeness, read-only routing URL, routing list on primary, non-default port documentation, MultiSubnetFailover guidance - **F19–F23** — Backup strategy: automated backup preference, preferred-replica guard function, log backup scheduling, compression, and missed offload opportunity - **F24–F27** — Endpoint security: cross-domain Windows auth, certificate expiry, RC4 algorithm, firewall port gaps - **F28–F33** — Distributed AG and advanced features: listener URL requirement for distributed AGs, Basic AG limits, Contained AG auth, synchronous distributed link, cross-database dependencies - **F34–F37** — Operational monitoring: Extended Events AG session, listener IP conformance, AG database-count scale ceiling, automatic seeding left active during a manual-restore workflow **Scope distinction:** T