memory per worker process

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.