DBA > Job Interview Questions > Microsoft SQL Server FAQs

What is the cost threshhold for parallelism in S

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the cost threshhold for parallelism in SQL Server 2005?

Answer
This is the number of seconds that a serialplan cannot exceed if it is to be used. A parallel plan is used if the estimate exceeds this value.

Explanation
This is the threshold at which SQL Server determines whether a serial or parallel plan is to be used. When SQL Server calculates that a serial plan exceeds the threshold, it will elect to use a parallel plan instead.

(Continued on next question...)

Other Job Interview Questions