Any suggestions? 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.

Return to top
Show:
© 2016 Microsoft