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.
Howard Stredwick commented
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.
Product Designer - SQL Monitor