- 2 minutes to read

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. Some examples of these maintenance jobs are among the following:

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

This feature comes with Nodinite version

Frequently asked questions

Additional solutions to common problems and the FAQ for the Nodinite System Parameters 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.

Next Step