DatabaseMaintenance - System Parameter
Keep the Nodinite Log Databases compact and tidy.
Nodinite by design, perform scheduled maintenance jobs. However, a SQL DBA may opt to use other mechanisms for these tasks for various reasons.
Use the System Parameter DatabaseMaintenance to control whether the Nodinite Logging Service performs the database maintenance jobs or not.
The database maintenance jobs start to execute sometime between 03:00 AM and 04:00 AM. The actual start time depends on other activities. The cleanup operation has a lower priority than other tasks and, therefore, executes after completing other tasks.
Active database
- Reindex - If the reported fragmentation count > 10%.
Archive databases
- Reindex - If the reported fragmentation count > 10%.
- Shrink - Tries to shrink the database to return allocated disk space to the system. Regular backup is a prerequisite.
The shrink operation is a privileged operation requiring the account configured to run the Logging Service to be assigned the sysadmin role.
Configuration example
| Field | Data Type | Description |
|---|---|---|
| Enabled | Boolean (true/false) |
When true, Nodinite performs database maintenance jobs, otherwise, it does not |
{"Enabled":true}
This feature comes with Nodinite version 4.3.0.45
Frequently asked questions
Additional solutions to common problems and the Nodinite System Parameters FAQ exist in 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 true, the Logging Service performs the maintenance jobs; otherwise, it does not. If you change this value, then you do NOT need to restart anything. Changes are effective almost immediately.