Summary information |
|
|---|---|
Default value |
1 |
Range of values |
0–1 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System Administrator |
The housekeeper garbage collection task performs space reclamation on data-only-locked tables. 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.
The housekeeper garbage collection task is controlled by enable housekeeper GC. For more information on the housekeeper garbage collection task see Chapter 4, “Using Engines and CPUs” in the Performance and Tuning: Basics.
sp_sysmon reports on how often the housekeeper garbage collection task performed space reclamation and how many pages were reclaimed. See the Performance and Tuning Guide for more information.
