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 process:

sp_configure "housekeeper free write percent", value

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

sp_configure "housekeeper free write percent", 2