Examples of setting parallel configuration parameters

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"