Scheduling service tasks

Adaptive Server allows you to manage service tasks (housekeeper, checkpoint, Replication Agent threads, and so on) with the sp_bindexeclass ‘sv’ execution class parameter. Binding individual service tasks to execution classes binds these tasks to thread pools, which lets you control dedicated resources for high-priority tasks, and keep service tasks from competing with user tasks.

NoteIn process mode, you cannot schedule service tasks.

For example, you can:

The monServiceTask monitoring table includes information about all service tasks that are bound to an execution class. This example shows the HK WASH and NETWORK HANDLER service tasks bound to the SC execution class:

task_id    spid        name
description                  execution_class
----------- ----------- ------------------------------
------------------------------ -----------------------
3932190               6                        HK WASH
                          NULL                      SC
4456482              10                NETWORK HANDLER
                          NULL                      SC