Summary information |
|
|---|---|
Default value |
1 |
Range of values |
0–1 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System Administrator |
When enable housekeeper GC is set to 1, the housekeeper task performs space reclamation on data-only-locked tables. housekeeper free write percent must also be set to greater than 0; if it is set to zero, the housekeeper task is disabled. When a user task deletes a row from a data-only-locked table, a task is queued to the housekeeper to check the data and index pages for committed deletes.
When enable housekeeper GC is set to 0, the housekeeper does not perform space reclamation. If all tables on your server use the allpages locking scheme, or if very few deletes or shrinking updates are performed on data-only-locked tables, setting enable housekeeper GC to 0 improves performance by slightly reducing housekeeper overhead. Use this setting:
If you use only allpages locking
If there are few deletes performed on your data-only-locked tables
If your workload leaves little idle CPU time
sp_sysmon reports on how often the housekeeper task performed space reclamation and how many pages were reclaimed. See the Performance and Tuning Guide.
