Knowlege base

Enable the automatic DB maintenance

Article ID: 836
Last updated: 28 Mar, 2021
Applies from Application Suite 2018.1.1
to version Application Suite 201x (any version)

Description:

This article describes how to enable the automatic execution of the suite database maintenance, to preserve the DB efficiency.

The DB maintenace procedure is executed every day at a configurable time. Since the execution could slow down some DB oprerations, it is recommended to schedule the execution in the off-peak hours (normally ar nigh time).

How-to:

1) Edit the file StonevoiceAS\Apps\FW\Settings\FW.Watchdog.Service.config.xml and add the following parameters (set the preferred execution time in the 24h format):

<preference key="dbmaintenance.execution.enabled" value="true" />
​<!-- Scheduled time of database maintenance operations (HH:mm, i.e. 24H format) --> 
​<preference key="dbmaintenance.execution.time" value="03:30" />

2) Save the file.

3) From the Windows Services panel restart the service "Imagicle Monitoring", to apply the change.

Notes for cluster configurations

In case of high availability configurations with mutiple Imagicle nodes:

  • if the database model is shared (all nodes pointing to the same DB), you must enable the DB maintenance on one Imagicle server only (tipically the first one);
  • if the databse model is replicated, you must schedule the maintenance on all Imagicle servers. The recommendation is to differentiate the execution time of at least 1-2 hours across the different nodes, because the simultaneous execution may raise temporary issues (and alerts) in the DB replication mechanism.

Article ID: 836
Last updated: 28 Mar, 2021
Revision: 4
Views: 20
Print Export to PDF Subscribe Share
This article was:  
Prev   Next
Migrating SQL Database to a different SQL instance (including...     How to install and use a certificate on Imagicle UC Suite server