To allow the housekeeper 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
The“Recovery management” on page 99 in the Performance and Tuning: Monitoring and Analyzing for Performance manual section of sp_sysmon shows checkpoint information to help you determine the effectiveness of the housekeeper.
