Symptoms

The Manager Interface takes a long time to load on startup and/or is very slow in refreshing on completion of an activity.
You may in certain circumstances see the message "The Service is unresponsive" appear in the Info Log pane, followed by "The Service is available" a few seconds later.

Reason

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 after an activity has been run, very slow.

Resolve

Upgrade to v3.3.17 or later.

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 with remove all records from the ActivityLog table older than 30 days.

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 this will depend on how many records are being deleted and on 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.

The database squeeze is preformed by selecting the FILE > DATABASE > SQUEEZE CURRENT DATABASE menu item.