DatabaseMaintenance - System Parameter
Keep your Nodinite Log Databases compact, healthy, and high-performing.
Nodinite is designed to perform scheduled maintenance jobs automatically, ensuring your integration platform remains efficient and reliable. However, a SQL DBA may choose to use alternative mechanisms for these tasks if preferred.
Use the System Parameter DatabaseMaintenance to control whether the Nodinite Logging Service performs these database maintenance jobs.
Maintenance jobs are scheduled to run between 03:00 AM and 04:00 AM, with the actual start time depending on other system activities. Cleanup operations have lower priority and execute after higher-priority tasks are completed.
Active database
- Reindex – Performed if the reported fragmentation count exceeds 10%.
Archive databases
- Reindex – Performed if the reported fragmentation count exceeds 10%.
- Shrink – Attempts to shrink the database to return allocated disk space to the system. Regular backups are a prerequisite.
The shrink operation is a privileged task requiring the account running the Logging Service to have the sysadmin role.
Configuration example
| Field | Data Type | Description |
|---|---|---|
| Enabled | Boolean (true/false) |
When true, Nodinite performs database maintenance jobs. When false, it does not. |
{"Enabled":true}
History
This feature is available from Nodinite version 4.3.0.45.
Frequently Asked Questions
Find more solutions and answers in the Nodinite System Parameters FAQ and the Troubleshooting user guide.
How do I change the value?
Changing a value for the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.
Do I need to restart anything?
If this system parameter is set to true, the Logging Service performs the maintenance jobs. If you change this value, you do NOT need to restart anything. Changes are effective almost immediately, ensuring minimal disruption and maximum agility.