enable housekeeper GC

enable housekeeper GC configures the housekeeper task.

Summary Information

Default value

1 (on)

Range of values

0 – 5

Status

Dynamic

Display level

Intermediate

Required role

System administrator

Configuration group

SQL Server Administration

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.

See Performance and Tuning Series: Basics > Using Engines and CPUs.

These are valid values for enable housekeeper GC:

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 Series: Monitoring SAP Adaptive Server with sp_sysmon.