Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Examples
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace