hadr-health-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–H27) across five 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, read-only routing not configured, and automatic seeding in progress - **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+) ## Input Accept any of: - **File path** — path to a saved text/CSV file containing the DMV query output - **Inline paste** — DMV result grid pasted directly into chat (tab- or pipe-delimited) - **Natural language description** — description