In Sql Management Studio (2008), Agent -> Alerts -> pick an alert -> Right-click -> Properties -> Response -> Email. Any way I can throttle these emails to one per 5 minutes? Getting 1000 emails in an hour doesn't help me answer the concern.
asked
Alerts Email Throttle?
If you are getting 1000 per hour, surely you could just turn off (disable) the alert for the time being? It meaningless to have the alert on until you have resolved the issue and any new alerts wont give any more info thatn the ones you already have.
Ahh, so this isnt a 24/7 condition. when it happens you get flooded, but you still need to know that the first time has happened? Could suggest trying SQL Monitor from RedGate
https://www.red-gate.com/products/dba/sql-monitor/. It would probably provide some filtering on it for you. I would also set up some Outlook rule to pop these emails into a folder other than my inbox to keep them generally out of the way.
... except that usually by the time I've found the alert I already have dozens. If I'm asleep when the issue begins (like I was night before last) then dozens turns to hundreds pretty quickly. I agree: it's meaningless to get more than one alert in a timeframe for an identical condition.
I am a huge fan of SQL Response, though I am not sure if it is an entire solution to this particular problem.
No, certainly not a solution but it might provide a filtering effect while the alert is disabled so that the email issue isnt there?? SQL Response could possibly collate and alert on the server condition until the underlying issue is resolved
What alerts are you getting?
I don't know of any way to throttle the number of emails down to a max threshold, I would be more worried that my system was generating 1000 alerts in an hour.
I still think it is worth solving the underlying issues rather than treating the symptoms....
Although not something I'd do for a generic alert, what about modifying the "Delay between responses" on the Options page of the alert?
You can crank up the delay to 720 minutes (12 hours).
