Configuration.MaxDegreeOfParallelism Property

 

Applies To: SQL Server 2016 Preview

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

public ConfigProperty MaxDegreeOfParallelism { get; }
public:
property ConfigProperty^ MaxDegreeOfParallelism {
    ConfigProperty^ get();
}
member MaxDegreeOfParallelism : ConfigProperty with get
Public ReadOnly Property MaxDegreeOfParallelism As 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

Legacy Code Example

Configuring SQL Server in SMO

See Also

Configuration Class
Microsoft.SqlServer.Management.Smo Namespace
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)

Return to top