topic Re: Grooming the SIM database in Server Management - Systems Insight Manager

Grooming the SIM database

Nate2272 — Wed, 02 May 2007 10:42:28 GMT

Hi,

I'm looking to groom our SIM databases for SIM (v5.0) running on MSDE 8.0.

Does anyone have any suggestions as to the easiest way to do this? One of our DBs is currently at 120k events, and no automatic Event handling had been set up.

I've managed to manually delete some informational/login events, but I was wondering if it's possible to delete events by date..and set this up via Automatic Event handling?

Thanks for any info you can provide.

Cheers,

Nate

Re: Grooming the SIM database

Daniel Leblanc — Wed, 02 May 2007 14:24:35 GMT

It is a way to clean event message,in HP SIM>OPTION>EVENTS>DELETE EVENT....you take what you want.

DOn not forget to apply the point.

Daniel

Re: Grooming the SIM database

Cindy Osborn — Wed, 02 May 2007 15:29:06 GMT

Nate,

I had this happen when I first had the 4.0 installed. It was hard to use the interface to delete the events when it was this many records. I finally deleted the events from the table in sql and then set up the automatic event handling. Seems like we had to set up queries older than so many days until we could it a query that was around 4k events. Finally I just said this ain't working and went into Enterprise manager and emptied the table.

Re: Grooming the SIM database

Nate2272 — Mon, 07 May 2007 09:42:51 GMT

Thanks,

I used the event deletion utility, but was curious about deleting events based on date (anything older than 90 days)? The MSDE db has grown to over 800 Mb, the interface was sluggish, at best. I found 2 servers primarily responsible for the DB growth, and
have removed their events to improve performance for the time being.

Thanks for the suggestions, all.

Nate