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.
In process mode, you cannot schedule service tasks.
For example, you can:
Bind the HK WASH housekeeping task to a specific service task.
Establish a Replication Agent pool and execution class with one thread per Replication Agent, giving dedicated resources, but simultaneously creating a more generic thread pool named service_pool, granting one thread to other tasks of lesser importance.
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