Effects of the housekeeper wash task on recovery time

Adaptive Server’s housekeeper wash task automatically begins cleaning dirty buffers during the server’s idle cycles. If the task can flush all active buffer pools in all configured caches, it wakes up the checkpoint process. This may result in faster checkpoints and shorter database recovery time.

System administrators can use the housekeeper free write percent configuration parameter to tune or disable the housekeeper wash task. This parameter specifies the maximum percentage by which the housekeeper task can increase database writes.

For more information on tuning the housekeeper and the recovery interval, see Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.