Use number of worker processes to specify the maximum number of worker processes that Adaptive Server can use at any one time for all simultaneously running parallel queries.
number of worker processes is a server-wide configuration parameter only; use sp_configure to set the parameter. For example, to set the maximum number of worker processes to 200, enter:
sp_configure “number of worker processes”, 200
