The housekeeper provides important functionalities:
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 0 0 9 sleeping NULL NULL 0 master HK GC 0 0 10 sleeping NULL NULL 0 master HK CHORES 0 0 12 recv sleep sa sa chaucer 0 (11 rows affected, return status = 0)
The general automatic restart of housekeeper-related system tasks: you need not restart the server if these system tasks quit unexpectedly.
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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
