mlxSQL

8.2.0.3

DSCResources/MSFT_xSQLMaxDop/MSFT_xSQLMaxDop.schema.mof

                                [ClassVersion("1.0.0.0"), FriendlyName("xSQLMaxDop")]

class MSFT_xSQLMaxDop : OMI_BaseResource

{

    [Write, Description("When set to 'Present' then max degree of parallelism will be set to either the value in parameter MaxDop or dynamically configured when parameter DynamicAlloc is set to $true. When set to 'Absent' max degree of parallelism will be set to 0 which means no limit in number of processors used in parallel plan execution."), ValueMap{"Present","Absent"}, Values{"Present","Absent"}] String Ensure;

    [Write, Description("If set to $true then max degree of parallelism will be dynamically configured. When this is set parameter is set to $true, the parameter MaxDop must be set to $null or not be configured.")] Boolean DynamicAlloc;

    [Write, Description("A numeric value to limit the number of processors used in parallel plan execution.")] Sint32 MaxDop;

    [Write, Description("The host name of the SQL Server to be configured. Default value is $env:COMPUTERNAME.")] String SQLServer;

    [Key, Description("The name of the SQL instance to be configured.")] String SQLInstanceName;

};