Solved!
Go to SolutionMW
Maarten Wijsman
8 Posts
0
165915
January 6th, 2015 05:00
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."
PatrickRAtDell
37 Posts
850
1
Posted 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
850
0
Posted January 20th, 2015 00:00
The SQL server has 2 vCPU's.
DELL-Andrew W1
378 Posts
850
0
Posted 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.