Share via

  • Artículo

MaximumDegreeOfParallelism Propiedad

Obtiene o establece el número máximo de procesadores que pueden usarse en una ejecución de plan paralelo que incluya la tabla.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
Public Property MaximumDegreeOfParallelism As Integer
    Get
    Set
'Uso
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)

Valor de la propiedad

Tipo: System. . :: . .Int32
Valor Int32 que especifica el número máximo de procesadores que pueden usarse en una ejecución de plan paralelo.

Ejemplos

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