Browsed by
Month: February 2016

Cost Threshold and Max Degree of Parallelism

Cost Threshold and Max Degree of Parallelism

SQL Server has many options for configuring a database system. Most do not become apparent until some part of the system does not function “properly”. Parallelism is one of these settings. You will see Waits for Parallelism and blocking if this setting is not effective. The SQL Server instance defaults for Max Degree of Parallelism is 0 and Cost Threshold is 5. What does this mean? Advanced SQL Server Instance Properties Maybe it is best to explain with an example….

Read More Read More