Partager via

  • Article

Propriété MaximumDegreeOfParallelism

Obtient ou définit le nombre maximal de processeurs à utiliser dans une exécution de plan parallèle qui inclut la table.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public Property MaximumDegreeOfParallelism As Integer
    Get
    Set
'Utilisation
Dim instance As Table
Dim value As Integer

value = instance.MaximumDegreeOfParallelism

instance.MaximumDegreeOfParallelism = value

public int MaximumDegreeOfParallelism { get; set; }

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

member MaximumDegreeOfParallelism : int with get, set

function get MaximumDegreeOfParallelism () : int
function set MaximumDegreeOfParallelism (value : int)

Valeur de propriété

Type : System. . :: . .Int32
Valeur Int32 qui spécifie le nombre maximal de processeurs à utiliser dans une exécution de plan parallèle.

Exemples

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["AdventureWorks2008R2"];

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("AdventureWorks2008R2")

#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