Managing the workload manager thread

The workload manager thread is a system-service thread that runs on each instance. When an instance starts, it automatically spawns the workload manager thread. This thread spends most of its time sleeping, but wakes up periodically to handle a logical cluster action, gather workload metrics, calculate the load on each instance, send load information to all instances, and other management duties.

You can view information about the workload manager by querying sysprocesses and monProcesses, using sp_who, and using other Adaptive Server capabilities for monitoring processes.

You may want to change the default value for maximum memory usage for the workload manager (see “Setting memory requirements for the workload manager”). Otherwise, the workload manager requires no maintenance.