topic Re: email flooding old events in Server Management - Systems Insight Manager

email flooding old events

david freeman_1 — Tue, 29 Mar 2005 11:21:57 GMT

Hi All

Have been running SIM 4.2 SP1 for a while now and been pretty happy with it. All of a sudden today it has started randomly flooding us with thousands of email alerts for old alerts months old.

Today I changed the config of the db to be simple and also truncated the transaction log as it was considerably larger than the db file !

Any thoughts as to if this is related to my problem ?? and if so what I can do to resolve it. I have doubled checked and I am definately on Sp1

Thanks

Dave

Re: email flooding old events

Stuart_43 — Wed, 30 Mar 2005 01:25:44 GMT

I had this issue when my sql server was out of disk space. would think it is a DB issue

Re: email flooding old events

david freeman_1 — Wed, 30 Mar 2005 05:57:26 GMT

No issue with disk space on the server, plenty available.

It appears that everytime the notification jobs run it pumps out every event, like its never marking them as being sent when it runs or something ?

Re: email flooding old events

steve christie_1 — Wed, 30 Mar 2005 15:36:17 GMT

I had this issue with the transaction log. Right click the database and go to properties/options, make sure the recovery type is set to simple and not full. This should drop the size down considerably

Re: email flooding old events

steve christie_1 — Thu, 31 Mar 2005 08:30:58 GMT

have you backed up your transaction log, this should purge all old transactions.

Re: email flooding old events

david freeman_1 — Thu, 31 Mar 2005 08:48:59 GMT

Yes the problem really started happening after I backed up and changed my db type.

I have rebuilt the server as it flooded our mail system so much they were queued and still coming through 4 hours after I turned off the server.... lets start again.