Table.MaximumDegreeOfParallelism Property

  • Article

 

Applies To: SQL Server 2016 Preview

Gets or sets the maximum number of processors to use in a parallel plan execution that includes the table.

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

Syntax

public int MaximumDegreeOfParallelism { get; set; }

public:
property int MaximumDegreeOfParallelism {
    int get();
    void set(int value);
}

member MaximumDegreeOfParallelism : int with get, set

Public Property MaximumDegreeOfParallelism As Integer

Property Value

Type: System.Int32

An Int32 value that specifies the maximum number of processors to use in a parallel plan execution.

Examples

Legacy Code Example

The following code example shows how to specify the maximum number of processors used for parallel plan executions that include the defined table.

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

Table tb = new Table(db, "Test Table");
Column col1 = new Column(tb, "Name", DataType.NChar(50));
Column col2 = new Column(tb, "ID", DataType.Int);

tb.Columns.Add(col1); 
tb.Columns.Add(col2); 
tb.MaximumDegreeOfParallelism = 3;
tb.Create();

Console.WriteLine("The maximum number of processors that can be used in parallel plan execution for this table is " + tb.MaximumDegreeOfParallelism);

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

#Create the Table
$tb = new-object Microsoft.SqlServer.Management.Smo.Table($db, "Tesghjt Table")
$col1 = new-object Microsoft.SqlServer.Management.Smo.Column($tb, "Name", [Microsoft.SqlServer.Management.Smo.DataType]::NChar(50))
$col2 = new-object Microsoft.SqlServer.Management.Smo.Column($tb, "ID", [Microsoft.SqlServer.Management.Smo.DataType]::Int)
$tb.Columns.Add($col1)
$tb.Columns.Add($col2)
$tb.MaximumDegreeOfParallelism = 3
$tb.Create()

Write-Host "The maximum number of processors that can be used in parallel plan execution for this table is" 
            $tb.MaximumDegreeofParallelism

See Also

Table Class
Microsoft.SqlServer.Management.Smo Namespace

CREATE TABLE (Transact-SQL)
Unable to find linked topic '811e00f9-303f-42b5-8bd4-2cdb829c84e9'.

Return to top