topic Re: E-Mail Flooding in Server Management - Systems Insight Manager

E-Mail Flooding

Pete Camp — Tue, 06 Sep 2005 19:47:46 GMT

Not a question, more of an observation really.
Over the past few weeks we have experienced SIM re-sending all the e-mail alerts it has ever generated, some 3,000 + emails, which I know others have experienced as well.
I have found that every time that we have experinced an email flood this ties in with a database issue (low disk space, transaction log backups failing for the insight database, etc. etc. new SQL server me thinks...)
Anyway it might be worth thinking about should you experince the same.

Re: E-Mail Flooding

Andy Cippico — Wed, 07 Sep 2005 07:22:18 GMT

We get this whenever one of our MS cluster resources fails. We then get 1600+ emails for events that have previously been sent.

We don't have a disk space issue and I can't see any tranaction log backups failing.
If anyone has any other ideas *please* let me know!

Thanks,
Andy.

Re: E-Mail Flooding

OlivierV — Thu, 08 Sep 2005 07:49:44 GMT

Did you set up a size limit for the SQL database log file ? If the log file reaches this limit, you can have this behaviour.

Re: E-Mail Flooding

OlivierV — Thu, 08 Sep 2005 07:51:51 GMT

Also, make sure the SQL services are always running when SIM is running. Never stop the SQL services when SIM is running, this was the origin of our eMail flooding.
Since the SIM service is stopped before SQL and and restarted after, no more flooding.

Regards.

Re: E-Mail Flooding

Andy Cippico — Thu, 08 Sep 2005 08:54:46 GMT

Thank you Oliver,

I have just discovered from an earlier post that SIM 4.2 SP2 fixes this problem. I have applied it and all seems well so far!
Thanks for you suggestions anyway.

Regards,
Andy.