sqlhadr-reviewlisted

# SQL Server Always On AG Health Review Skill ## Purpose Analyze output from the `sys.dm_hadr_*` DMV family to assess the health of one or more Always On Availability Groups. Applies 27 checks (H1–H28, with H21 retired and merged into `sqlag-review` F15 — see Category 4) across six categories: - **H1–H6** — Replica connectivity and role: detect disconnected replicas, resolving state, unhealthy synchronization health, replicas not synchronizing, last-connect errors, and failover mode mismatches - **H7–H11** — Data loss and recovery time: flag estimated data loss, excessive recovery time, secondary lag, redo queue buildup, and log send queue buildup - **H12–H16** — Throughput and performance: detect stalled redo rate, stalled log send rate, rate mismatch causing queue accumulation, multiple databases lagging on the same replica, and commit latency signals on sync-commit replicas - **H17–H22** — Configuration: async replica in unexpected position, no automatic failover replica, single-replica AG, missing listener, and automatic seeding in progress (H21 is retired — read-only routing absence is covered by `sqlag-review` F15) - **H23–H27** — Modern AG features: Contained AG DML misrouting, Cloud Witness inaccessible, Parallel Redo saturation, Read-Scale secondary missing RCSI, AG without database-level health detection (SQL 2012–2022+) - **H28** — Seeding and initialization integrity: database stuck in INITIALIZING synchronization state, particularly after a failo