The housekeeper provides important functionalities:
the general automatic restart of housekeeper-related system tasks: you need not restart the server if these system tasks quit unexpectedly.
The housekeeper feature consists of three tasks: housekeeper wash, housekeeper garbage collection, and housekeeper chores. sp_who recognizes all three tasks, as the following output shows:
fid spid status loginame origname hostname blk_spid dbname cmd block_xloid
0 8 sleeping NULL NULL 0 master HK WASH 00 9 sleeping NULL NULL 0 master HK GC 00 10 sleeping NULL NULL 0 master HK CHORES 00 12 recv sleep sa sa chaucer 0(11 rows affected, return status = 0)
A System Administrator can change all housekeeper task priorities.
sp_showpsexe, as well as sp_who, recognizes all three housekeeper names.
For more information about sp_who and sp_showpsexe, see the Reference Manual.
