Summary information |
|
|---|---|
Default value |
1024 |
Range of values |
1024–2147483647 |
Status |
Dynamic |
Display level |
Basic |
Required role |
System Administrator |
memory per worker process specifies the amount of memory (in bytes) used by worker processes. Each worker process requires memory for messaging during query processing. This memory is allocated from a shared memory pool; the size of this pool is memory per worker process multiplied by number of worker processes. For most query processing, the default size is more than adequate. If you use dbcc checkstorage, and have set number of worker processes to 1, you may need to increase memory per worker process to 1792 bytes. See Chapter 9, “Parallel Sorting” of the Performance and Tuning Guide: Optimizer and Abstract Plans for information on setting this parameter.
For more information on Adaptive Server’s memory allocation, see Chapter 18, “Configuring Memory.”
