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