Allowing the housekeeper wash task to work continuously

To allow the housekeeper wash task to work whenever there are idle CPU cycles, regardless of the percentage of additional database writes, set the value of the housekeeper free write percent parameter to 100:

sp_configure "housekeeper free write percent", 100

See Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.