Allowing the housekeeper task to work continuously

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.