Configuring the Maximum Degree of Parallelism This is an off-site link.  Please review our Terms of Service for additional information.

(Rod Colledge) A commonly altered setting is Maximum Degree of Parallelism (MAXDOP), which controls the maximum number of CPUs that can be used in executing a single task. For example, a large query may be broken up into different parts, with each part executing threads on separate CPUs. Such a query is known as a parallel query.

Read this article...

comments powered by Disqus