max degree of parallelism
Type: Advanced
Default value: 0
The 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 2008 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 ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
