Sql Database size

[So Def]

I am using SIM 4.0 with the databases on external sql 2000 server. I noticed that the sql databases and logfiles together are 10 GB in size. Is there a way to reduce the amount of diskspace SIM wil use.

Also is there any news when the 4.1 version will be released which allows an upgrade from 4.0? I don't want to start all over again and lots of time and history is in my current database.

[Joel Rubenstein · Accepted solution]

Using SQL enterprise manager you need to change the Insight_v1_0 database recovery model to "simple" and then shrink the database.

Upgrades from SIM 4.0 will be supported in SIM 4.2 due out later this year.

[So Def]

Thanks, that surely helped. Database is now 4 Gb in size instead of 10 GB.

patiently waiting for version 4.2 to upgrade from 4.0 :)

[Joel Rubenstein]

4 GB is still a very large SIM database. You might want to create a scheduled task to delete old events.

[So Def]

How do I do this exactly? Is this done by configuring an automatic event handling?
Currently our events are forwarded to a specific emailaddress. btw currently all our allerts are send to an ICT support email group. Is it possible that besides sending all alerts also to one email address, to use a different emaill address triggered only by specific events. We want to use an sms bridge to send a GSM alert to a mobile phone for critical alerts but also to maintain the ability to send all events to another address.

[Joel Rubenstein]

SIM does not automatically delete old events. To delete old events.


First define an Event list that pulls up all events older than xx days.

Second, use the Delete Events task (under Options->Events->Delete Events...) to create a periodic task that runs every so often against that event list.

[So Def]

Thanks that was indeed the problem. hehe storing 34.000 events is a bit overkill :)

that leaves the other Q:

currently all our allerts are send to an ICT support email group. Is it possible that besides sending all alerts also to one email address, to use a different emaill address triggered only by specific events. We want to use an sms bridge to send a GSM alert to a mobile phone for critical alerts but also to maintain the ability to send all events to another address.

Is this possible?

[Joel Rubenstein]

Have you tried creating a second automatic event handling task for the critical events. You could them specify an alternate e-mail address.