This post is more than 5 years old
8 Posts
0
165841
SQL - Maximum degree of Parallelism
Hi,
What is the common practice from Dell Wyse vWorkspace standpoint regarding this SQL setting? It could boost performance as I have understood it correctly.
More information here > support.microsoft.com/.../2806535
"The Microsoft SQL Server max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan. This option determines the computing and thread resources that are used for the query plan operators that perform the work in parallel."
DELL-Andrew W1
378 Posts
0
January 19th, 2015 04:00
Hello Maarten,
Maxdop set to 0 (Which I believe it is by default) works for most people.
How many processors do you have on your SQL box?
Thanks, Andrew.
PatrickRAtDell
37 Posts
1
January 23rd, 2015 03:00
This should not be a concern with only 2 processors. This is for when you have a lot of processors and want to limit the execution to a number lower than the maximum.
Maarten Wijsman
8 Posts
0
January 20th, 2015 00:00
The SQL server has 2 vCPU's.