Configuration.MaxDegreeOfParallelism Property

Gets the ConfigProperty object that is used to set the max degree of parallelism configuration option.

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

Syntax

'Declaration
Public ReadOnly Property MaxDegreeOfParallelism As ConfigProperty 
    Get
'Usage
Dim instance As Configuration 
Dim value As ConfigProperty 

value = instance.MaxDegreeOfParallelism

public ConfigProperty MaxDegreeOfParallelism { get; }

public:
property ConfigProperty^ MaxDegreeOfParallelism {
    ConfigProperty^ get ();
}

member MaxDegreeOfParallelism : ConfigProperty

function get MaxDegreeOfParallelism () : ConfigProperty

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the max degree of parallelism configuration option.

Remarks

This property specifies maximum number of processors, up to 32, to use in parallel plan execution.

Examples

Configuring SQL Server in SMO

See Also

Reference

Configuration Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Server Configuration Options (SQL Server)

sp_configure (Transact-SQL)