Creating Thread Pools

Group Adaptive Server engines into thread pools.

Thread pools are groups of resources, such as engines, that execute user tasks, run specific jobs such as signal handling, and process requests from a work queue. Adaptive Server supports both system-defined and user-defined thread pools.

Note: Thread pools can only be configured in Adaptive Server 15.7 and later versions. To use thread pools, Adaptive Server must be configured to run in threaded mode.
  1. In the Administration Console view, select ASE Servers > Performance > Thread Pools.
  2. Select New.
    You see the Add Thread Pools wizard.
  3. Select an Adaptive Server that is configured to run in threaded mode.
  4. Specify the name of the thread pool you want to create.
    Note: You cannot name thread pools starting with a syb_ prefix since that is reserved for system thread pools.
  5. Specify the number of threads. The maximum number of threads you can configure is the configured value of max_online_engines.
  6. (Optional) Click Preview to see the SQL statements for your command.
  7. (Optional) Click Summary to verify your selected options.
Parent topic: Performance
Related tasks
Creating Execution Classes
Creating Engine Groups
Related reference
Thread Pool Properties
Execution Classes Properties
Engine Groups Properties
Thread Statistics and Details