Skip to content

In Redgate Monitor, I want to...

← Suggestions

With the AG Groups it would be good to have soft alerting on configurations

With the AG it is possible to have different configuration on the server replicas. We mostly get caught out with Logins. but have had issues with XMLBlob size, linked servers and Server Master Keys.

It would be good for monitor to alert (or be able to alert) if a Login does not exist on both (all) replicas. we have times when a quick addition through SSMS does not put the same login on all side. when fail over occurs we then have broken processing. It would be good for sids to be checked as well as this is another issue when the SQL Auth is used but sid on both sides is different.
We also have Service Master key issues where different keys are set up then the database master key will fail on AG Failover and need manually opening. a simple check on both sides would be useful.

6 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Phil Quinn shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Howard Stredwick commented  ·   ·  Report

    Hi Phil,

    Good suggestion. We are doing some work at the moment around monitoring instance configurations. We are about to release an update that allows alerting on configuration changes however in the future we think AG config and the specific challenges it has is a an area where we can add some more value. We can get in touch at the time to get your feedback on where we take it.

    Thanks again,

    Howard
    Product Designer - SQL Monitor

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)