Parallel Query Configuration Options
Two server configuration options—maximum degree of parallelism and cost threshold for parallelism—affect the consideration for a parallel query. For single processor systems, these settings are ignored. On multi-processor systems, you may need to change the default settings for one or both of these options, but this should not be done arbitrarily. Proper settings depend on the number of available processors and the type and volume of activity the system will experience.
Note
Before making adjustments to these settings, you should first establish some baseline performance statistics as the system and query level. Then adjust the setting based upon typical recommendations provided in this section and compare ...
Get Microsoft SQL Server 2014 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.
