December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
cost threshold for parallelism
Type: Advanced
Default value: 5
SQL Server 2012 supports parallel query execution. Before a query is executed, SQL Server’s cost-based optimizer estimates the cost of execution for a serial plan (that is, a plan that uses a single thread). The option to set the cost threshold for parallelism allows you to specify a threshold in seconds; if the cost of the serial execution plan (in seconds) is greater than the value specified by this parameter, SQL Server considers a parallel query execution plan. A query does not become a candidate for parallel query execution simply based on this fact. Because parallel query execution is supported only on multiprocessor servers, the cost threshold for parallelism value is ignored ...