| 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 | 
number of worker processes specifies the maximum number of worker processes that Adaptive Server can use at any one time for all simultaneously running parallel queries combined.
Adaptive Server 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.
| Copyright © 2005. Sybase Inc. All rights reserved. |   | |