How can we help you today? How can we help you today?

Question about Always On monitor capabilities

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!
Nathan Wilson
0

Comments

3 comments

Sort by
  • 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?

    squigley
    0
  • cnwilson
    Yes, we are using the built in Server Waits alert. Is it possible to ignore secondary replicas with custom metric alerts?
    cnwilson
    0
  • 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
    0

Add comment

Please sign in to leave a comment.