Always On Health Report - AG_PROD_01
SQLNODE01 | 2026-07-19 16:06:00 | Status: Healthy
Source: www.powershelldba.de | sqmSQLTool v1.9.26.1
Illustrative example — this lab instance has no Always On Availability Group configured (single-node, HADR disabled). Values below are representative, not measured output.
| Replicas |
|---|
| Replica | Role | Availability Mode | Health / Connection |
|---|
| SQLNODE01 | PRIMARY | SYNCHRONOUS_COMMIT | HEALTHY / CONNECTED |
| SQLNODE02 | SECONDARY | SYNCHRONOUS_COMMIT | HEALTHY / CONNECTED |
| Database Synchronization |
|---|
| Database | Replica | State | Redo Queue | Send Queue |
|---|
| AG_TestDB | SQLNODE01 (Primary) | SYNCHRONIZED | 0 KB | 0 KB |
| AG_TestDB | SQLNODE02 | SYNCHRONIZED | 12 KB | 4 KB |
| Listener & AutoSeed |
|---|
| Listener name | AG-LISTENER01 |
| Listener endpoint | 10.0.1.50:1433 |
| AutoSeed operations running | None |
Thresholds: redo queue 100 MB, send queue 50 MB - no replica exceeded either threshold.