Disabling the housekeeper task

You may want to disable the housekeeper task to establish a controlled environment in which only specified user tasks are running. To disable the housekeeper task, set the value of the housekeeper free write percent parameter to 0:

sp_configure "housekeeper free write percent", 0

WARNING!  In addition to buffer washing, the housekeeper periodically flushes statistics to system tables. These statistics are used for query optimization, and incorrect statistics can severely reduce query performance. Do not set the housekeeper free write percent to 0 on a system where data modification commands may be affecting the number of rows and pages in tables and indexes.