Question about Always On monitor capabilities

cnwilson

We have a case where we'd like to set an alert for wait statistics in an Always On instance. The alert is being tripped by the secondary replica with normal sync activity. Can we set an alert to ignore the secondary replicas?

We are on version 11.0.18.5710. Thanks for any assistance!

squigley

Thanks for the update on your end.
Unfortunately there isn't an "ignore this secondary replica" option natively available within SQL Monitor. We would recommend working around this via disabling it at that server level (and then re-enable it if there was a fail-over and disable it on the new secondary). Apologies for the inconvenience that this brings.

If you would like for this to become a native feature I would highly recommend creating a user-voice request so that the developers can see the demand for it: https://sqlmonitor.uservoice.com/forums/91743-suggestions

Thanks!

squigley

Thanks for your inquiry with SQL Monitor.

Can you confirm if this planned via the built in "Server waits" alert or a custom metric or something else?

cnwilson

Yes, we are using the built in Server Waits alert. Is it possible to ignore secondary replicas with custom metric alerts?