Monthly Archives October 2015

Best Practices for “max degree of parallelism” configuration setting

by Snehashish Ghosh

No of Processor Core Cores is a hardware term that describes the number of independent central processing units in a single computing component (die or chip).

No of Processor Threads A Thread, or thread of execution, is a software term for the basic ordered sequence of instructions that can be passed through or processed by a single CPU core.

What is max degree of parallelism

  • max degree of parallelism configuration option limits the number of processor core to use in parallel plan execution.
  • This option determines the computing and thread resources that are used for the query plan operators that perform the work in parallel.

Recommendations and guidelines for the max degree of parallelism configuration option

Best practice is to set max degree of parallelism to a value that is equal t...

Read More