How many worker processes are enough?
A worker process is a new type of task that handles parallel queries, parallel index creation and parallel dbcc scans. The number of worker processes is limited only by the amount of memory available to the server and is a configurable value (number of worker processes). Each worker process consumes about the same memory as a user connection. In multi-user environments that use parallelism, it is important to balance between the number of users and number of worker processes.
