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.

more ▼

asked Jan 14, 2010 at 01:32 PM in Default

avatar image

Rob 3
11 1 1 3

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Jan 15, 2010 at 06:33 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

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

Jan 15, 2010 at 11:50 AM Rob 3

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.

Jan 15, 2010 at 01:24 PM Fatherjack ♦♦

I am a huge fan of SQL Response, though I am not sure if it is an entire solution to this particular problem.

Jan 15, 2010 at 01:53 PM TimothyAWiseman

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

Jan 15, 2010 at 05:55 PM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jan 14, 2010 at 02:15 PM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

It's stuff like "this db failed over". The app needs repair as well, but blocking the emails is the current symptom of concern.

Jan 14, 2010 at 09:41 PM Rob 3

Or like a db login attempt failed because the box got port-scanned.

Jan 14, 2010 at 09:57 PM Rob 3

I still think it is worth solving the underlying issues rather than treating the symptoms....

Jan 15, 2010 at 08:39 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Feb 26, 2010 at 02:06 AM

avatar image

92 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 14, 2010 at 01:32 PM

Seen: 2626 times

Last Updated: Aug 07, 2017 at 09:30 AM

Copyright 2018 Redgate Software. Privacy Policy