Monitoring a distributed availability group

Troubleshooting
1

CMK version: 2.5.0p11 Pro
OS version: Ubuntu 22.04

Error message: Primary replica: XXXXXX, Synchronization state: NOT_HEALTHY

The MSSQL Availability Group detection runs on all nodes of a SQL AlwaysOn cluster. When you have a distributed availability group (in our case an Azure copy) there are no replica rows on the node that isn’t the primary member of the AG. This leaves the secondaries with a NOT_HEALTHY message. Is there a way to keep the state as HEALTHY on nodes that are not primary for these distributed AGs?

2

Is that a task for a cluster host perhaps?

3

I suppose you could go that route but it requires manual creation of a cluster with no IP address for every remote database. Having the SQL check for is_distributed and validate it is the primary member before reporting NOT_HEALTHY would simplify discovery and setup.