Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Configuration.CostThresholdForParallelism Property

Gets the ConfigProperty object that is used to set the cost threshold for parallelism configuration option.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public ConfigProperty CostThresholdForParallelism { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the cost threshold for parallelism configuration option.

This property specifies the maximum query execution time for a serial plan on a symmetric multiprocessor (SMP) system. If the estimated execution time is larger than this value, a parallel plan is executed.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft