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)
Syntax
'Declaration
Public ReadOnly Property CostThresholdForParallelism As ConfigProperty
Get
'Usage
Dim instance As Configuration
Dim value As ConfigProperty
value = instance.CostThresholdForParallelism
public ConfigProperty CostThresholdForParallelism { get; }
public:
property ConfigProperty^ CostThresholdForParallelism {
ConfigProperty^ get ();
}
member CostThresholdForParallelism : ConfigProperty
function get CostThresholdForParallelism () : ConfigProperty
Property Value
Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the cost threshold for parallelism configuration option.
Remarks
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.
See Also