Can someone explain, in plain English, what is the Max Degree of Parallelisme?
Let 's say I have 2 CPUs, if I set the value MDOP to 0 then each query will use both CPUs, if I set it to 1 then each query will use 1 CPU at a time. I hope I am correct.
So where the advantage/disadvantage of using 0 or 1 ?
Any help will be very much appreciated.