Disabling the housekeeper wash task

Disable the housekeeper wash task to establish a more controlled environment in which primarily user tasks are running. To disable the housekeeper wash task, set the value of the housekeeper free write percent parameter to 0:

sp_configure "housekeeper free write percent", 0

There is no configuration parameter to shut down the housekeeper chores task, although you can set sp_setpsexe to lower its priority.