topic Re: Sql Database size in Server Management - Systems Insight Manager

Sql Database size

So Def — Thu, 22 Jul 2004 09:35:37 GMT

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.

Re: Sql Database size

Joel Rubenstein — Thu, 22 Jul 2004 09:44:58 GMT

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.

Re: Sql Database size

So Def — Thu, 22 Jul 2004 10:08:32 GMT

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 :)

Re: Sql Database size

Joel Rubenstein — Thu, 22 Jul 2004 10:12:51 GMT

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

Re: Sql Database size

So Def — Thu, 22 Jul 2004 10:42:04 GMT

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.

Re: Sql Database size

Joel Rubenstein — Thu, 22 Jul 2004 10:52:54 GMT

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.

Re: Sql Database size

So Def — Thu, 22 Jul 2004 11:08:19 GMT

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?

Re: Sql Database size

Joel Rubenstein — Thu, 22 Jul 2004 11:19:15 GMT

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