| AG_PROD_01 (Site A, local) | ||||
|---|---|---|---|---|
| Replica | Role | Availability Mode | Sync Health | Connection |
| SQLNODE01 | PRIMARY | SYNCHRONOUS_COMMIT | HEALTHY | CONNECTED |
| SQLNODE02 | SECONDARY (Forwarder) | SYNCHRONOUS_COMMIT | HEALTHY | CONNECTED |
| AG_DR_01 (Site B, remote) | ||||
|---|---|---|---|---|
| Replica | Role | Availability Mode | Sync Health | Connection |
| SQLNODE03 | PRIMARY | ASYNCHRONOUS_COMMIT | HEALTHY | CONNECTED |
| Cross-Site Replication | ||
|---|---|---|
| Forwarder | SQLNODE02 → SQLNODE03 | |
| Redo Queue (Site B) | 340 KB | |
| Send Queue (Site B) | 88 KB | |