Hello Sir, Thanks a lot for the video on AO alerting. I have tried setting up the below alerts and started getting thousands of emails. close to 95,000 emails. May I know the best way to handle this? Also, my second question is, Is it possible to alert (send email) the query which has caused the Latency issues ? ('1480' , 'AG Role Change (failover)') , ('976' , 'Database Not Accessible') , ('983' , 'Database Role Resolving') , ('3402' , 'Database Restoring') , ('19406', 'AG Replica Changed States') , ('35206', 'Connection Timeout') , ('35250', 'Connection to Primary Inactive') , ('35264', 'Data Movement Suspended') , ('35273', 'Database Inaccessible') , ('35274', 'Database Recovery Pending') , ('35275', 'Database in Suspect State') , ('35276', 'Database Out of Sync') , ('41091', 'Replica Going Offline') , ('41131', 'Failed to Bring AG Online') , ('41142', 'Replica Cannot Become Primary') , ('41406', 'AG Not Ready for Auto Failover') , ('41414', 'Secondary Not Connected');
I have tried setting up the below alerts and started getting thousands of emails. close to 95,000 emails. May I know the best way to handle this? >> I cannot exactly say cause of the excessive alerts without checking your environment. The below might be possible causes: a. you are setting thresholds very low causing trigger often. In this case, you should increase threshold b. The performance of AG is very slow causing alerts to be fired. In this case, you need to troubleshoot performance. I believe you know my session on this :) c. You set alerts wrongly. Have you set equations correctly? It is difficult for me to give any suggestions without looking at your environment and settings... Sorry
Thank you, its very helpful
Glad it was helpful!
Thanks very helpful
Glad you found it helpful!
Hello Sir, Thanks a lot for the video on AO alerting. I have tried setting up the below alerts and started getting thousands of emails. close to 95,000 emails. May I know the best way to handle this?
Also, my second question is, Is it possible to alert (send email) the query which has caused the Latency issues ?
('1480' , 'AG Role Change (failover)')
, ('976' , 'Database Not Accessible')
, ('983' , 'Database Role Resolving')
, ('3402' , 'Database Restoring')
, ('19406', 'AG Replica Changed States')
, ('35206', 'Connection Timeout')
, ('35250', 'Connection to Primary Inactive')
, ('35264', 'Data Movement Suspended')
, ('35273', 'Database Inaccessible')
, ('35274', 'Database Recovery Pending')
, ('35275', 'Database in Suspect State')
, ('35276', 'Database Out of Sync')
, ('41091', 'Replica Going Offline')
, ('41131', 'Failed to Bring AG Online')
, ('41142', 'Replica Cannot Become Primary')
, ('41406', 'AG Not Ready for Auto Failover')
, ('41414', 'Secondary Not Connected');
I have tried setting up the below alerts and started getting thousands of emails. close to 95,000 emails. May I know the best way to handle this?
>> I cannot exactly say cause of the excessive alerts without checking your environment. The below might be possible causes:
a. you are setting thresholds very low causing trigger often. In this case, you should increase threshold
b. The performance of AG is very slow causing alerts to be fired. In this case, you need to troubleshoot performance. I believe you know my session on this :)
c. You set alerts wrongly. Have you set equations correctly?
It is difficult for me to give any suggestions without looking at your environment and settings... Sorry