memory per worker process specifies the amount of memory, in bytes, used by worker processes.
|
Summary Information |
|
|---|---|
|
Default value |
1024 |
|
Range of values |
1024–2147483647 |
|
Status |
Dynamic |
|
Display level |
Basic |
|
Required role |
System administrator |
|
Configuration group |
Memory Use |
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 System Administration Guide: Volume 2 > Configuring Memory.