Group SAP ASE engines into thread pools.
Prerequisites
Set the kernel mode to threaded. You can change the kernel mode on the
Server Configuration screen, or by executing this command at the server level from the
Administration Console.
sp_configure "kernel
mode", 0, threaded
You must restart SAP ASE for the change to take
effect.
Task
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. Both
system-defined and user-defined thread pools are supported.
- In the left pane of the Administration Console, expand , then select Thread Pools.
- Select New.
- On the Introduction screen, select a server that is configured to
run in threaded mode.
- (Optional) For a cluster environment, click Create this as local thread pool, then select the cluster instance on which the thread pool will be created.
- On the Thread Pool Name screen, 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.
- On the Thread count screen, specify the number of threads. The maximum number
of threads you can configure cannot exceed the value of max
online engines.
- Specify the thread pool idle time out in microseconds.
- (Optional) Provide a description for the thread pool.
- (Optional) Click Preview to see the SQL statements for your command.
- (Optional) Click Summary to verify your selected options.