How can I reduce the growth of the database for the Kiwi CatTools?

Issue:

Every time an activity is run, the ActivityLog table in the database is updated with the run status of the activity. Over time this can cause the database to grow to quite a large size and make the loading of the Manager interface or refreshing of the Manager interface very slow after an activity has been run.

Resolution:

You need to upgrade to v3.3.17 or later version.

In v3.3.17 a daily purge of the ActivityLog table is now performed after the first activity for the day has completed. The purge will remove all records older than 30 days from the ActivityLog table.

If the database has grown to a very large size, then the first purge may take a minute or so to complete. Subsequent purges should only take a second or two, but will depend on how many records are being deleted and the system resources/specification.

To keep the database at its optimum size, you may also want to perform a regular (maybe once a week) 'squeeze' of the database. This will compress the database to its smallest size.

To perform the database squeeze:

Select the following item from the menu: FILE > DATABASE > SQUEEZE CURRENT DATABASE

Applies to:

Kiwi CatTools v3.0
Kiwi CatTools v3.1
Kiwi CatTools v3.2
Kiwi CatTools v3.3

No related articles were found.

Attachments

No attachments were found.

Visitor Comments

No visitor comments posted. Post a comment

Post Comment for "How can I reduce the growth of the database for the Kiwi CatTools?"

If this article does not provide the solution you need, please consider visiting our community forums on thwack or contacting SolarWinds Support. Please use the following form to provide comments that help us improve this KB article. Fields marked with an asterisk are required.