Make the alerting system AG Aware
Similar in nature to the Job Duration Unusual Alert should be AG aware - there are many alerts we do not want to see on an AG secondary unless it is set to readable - things like server waits due to queries running on master etc generate alerts when running against a base line but we dont need to get the alert/notification if the AG is set to secondary
6
votes