Enable the automatic DB maintenance
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).
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.
This article was:
Thank you for your feedback!
|Migrating SQL Database to a different SQL instance (including...||How to install and use a certificate on Imagicle UC Suite server|