Figure 1: Background Tasks Tab
Enable Background Index Optimizer
If checked, an optimizer is watching database access. If a "View" needs longer to prepare than "Minimum Idle Time" a popup appears. Asking if database tables should be indexed in order to get a better performance.
Minimum Idle Time
Time in seconds the Index Optimizer should wait until it fires. The optimizer will only run if the runtime of a "View" is higher than Minimum Idle Time.
Enable Background Database Cleanup
If enabled a background mechanism periodically checks if there are old records in the database which should be deleted.
Minimum Idle Time
The time interval in seconds the Background Database Cleanup checks for old records.
Delete records older than 'x' days
This option allows you to delete all of the records older than 'x' number of days where x is user defined.
On the basis of
This option allows you to delete on the basis of DeviceReportedTime and ReceivedAt Time (these fields are defined in the SystemEvents Table).
Note: DeviceReportedTime and ReceivedAt Time are different from each other.
The DeviceReportedTime is actually the time that is there in the Windows Event Log i.e. the time at which the (e.g. syslog) message was written into the Windows Event Log.
ReceivedAt time on the other hand is the time when the (e.g. Syslog) message is received at the configuration program e.g. MonitorWare Agent.