question

Rob 3 avatar image
Rob 3 asked

Alerts Email Throttle?

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.

ssmssql-agentalerts
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

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.

4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
2 Likes 2 ·
... 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.
0 Likes 0 ·
I am a huge fan of SQL Response, though I am not sure if it is an entire solution to this particular problem.
0 Likes 0 ·
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
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered

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.

3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I still think it is worth solving the underlying issues rather than treating the symptoms....
1 Like 1 ·
It's stuff like "this db failed over". The app needs repair as well, but blocking the emails is the current symptom of concern.
0 Likes 0 ·
Or like a db login attempt failed because the box got port-scanned.
0 Likes 0 ·
philcart avatar image
philcart answered

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).

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.