number of worker processes

number of worker processes specifies the maximum number of worker processes that SAP ASE can use at any one time for all simultaneously running parallel queries.

Summary Information

Default value

0

Range of values

0–2147483647

Status

Dynamic

Display level

Basic

Required role

System administrator

Configuration groups

Memory Use, Query Tuning

SAP ASE issues a warning message at start-up if there is insufficient memory to create the specified number of worker processes. memory per worker process controls the memory allocated to each worker process.

If you have not configured number of worker processes for a sufficient number of threads from the worker thread pool, SAP ASE adjusts query plans at runtime to use fewer worker threads. If SAP ASE cannot adjust the queries at runtime, the queries recompile serially. However, alter table and execute immediate commands are aborted if they do not have sufficient worker threads.