Changing the percentage by which writes can be increased

Use sp_configure to change the percentage by which database writes can be increased as a result of the housekeeper wash task:

sp_configure "housekeeper free write percent", value

For example, to stop the housekeeper wash task from working when the frequency of database writes reaches 2 percent above normal enter:

sp_configure "housekeeper free write percent", 2