x

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

Rob 3 gravatar image

Rob 3
11 1 1 1

(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

Fatherjack gravatar image

Fatherjack ♦♦
42.6k 75 79 108

... 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 Response from RedGate http://www.red-gate.com/products/SQL_Response/index.htm. 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

Kev Riley gravatar image

Kev Riley ♦♦
53k 47 49 76

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

philcart gravatar image

philcart
82

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x125
x89
x11

asked: Jan 14, 2010 at 01:32 PM

Seen: 1743 times

Last Updated: Feb 17, 2010 at 07:25 AM