The following command sets number of worker processes:
sp_configure "number of worker processes", 50
After a restart of the server, these commands set the other configuration parameters:
sp_configure "max parallel degree", 10 sp_configure "max scan parallel degree", 3
To display the current settings for these parameters, use:
sp_configure "Parallel Query"
