max degree of parallelism option specifies the number of threads to be used for parallel query execution. On a single-processor server, this value is always ignored. For multiprocessor servers, a default value of
0 signifies that all the CPUs will be used for parallel query execution. When SQL Server 2012 runs on a machine that has more than one processor, it detects the best degree of parallelism. If you set this value to
1, all query plans are serialized. If the
affinity mask option is on, parallel query execution takes place only on the CPUs for which the
affinity mask bit is turned on. In that way, these two options can be used in conjunction. The application types assessment is ...