Search SSWUG.ORG:



DATABASES

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