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” section of sp_sysmon shows checkpoint information to help you determine the effectiveness of the housekeeper.
