Use max parallel degree to specify the maximum number of worker processes allowed per query. You can configure max parallel degree at the server or the session level.
For example, to set max parallel degree to 60 at the server level, enter:
sp_configure “max parallel degree”, 60
To set max parallel degree to 60 at the session level, enter:
set parallel_degree 60
The value of max parallel degree must be equal to or less than the current value of number of worker processes. Setting max parallel degree to 1 turns off parallel processing—Adaptive Server scans all tables and indexes serially. To enable parallel partition scans, set max parallel degree equal to or greater than the number of partitions in the table you are querying.
