E-Mail Flooding

[Pete Camp]

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.

[Andy Cippico]

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.

[OlivierV]

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.

[OlivierV]

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.

[Andy Cippico]

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.