What are the challenges you face when working across database platforms? Take the survey
Options

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!

Best Answer

  • Options
    squigleysquigley Posts: 237 Gold 1
    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!

    Sean Quigley | Product Support Engineer | Redgate Software

    Have you visited our Help Center?





Answers

Sign In or Register to comment.