Resource Type: dsc_sqlmaxdop

Defined in:

lib/puppet/type/dsc_sqlmaxdop.rb

Overview

The DSC SqlMaxDop resource type. Automatically generated from version 16.6.0

Properties

• dsc_dynamicalloc

  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.

• dsc_ensure

  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.

• dsc_isactivenode

  Determines if the current node is actively hosting the _SQL Server_ instance.

• dsc_maxdop

  A numeric value to limit the number of processors used in parallel plan execution.

• dsc_processonlyonactivenode

  Specifies that the resource will only determine if a change is needed if the target node is the active host of the _SQL Server_ instance.

• dsc_servername

  The host name of the _SQL Server_ to be configured. Default value is the current computer name.

Parameters

• dsc_instancename (namevar)

  The name of the SQL instance to be configured.

• dsc_psdscrunascredential
• dsc_timeout

  The maximum time in seconds to wait for the DSC resource to complete.

• name (namevar)

  Description of the purpose for this resource declaration.

• validation_mode (defaults to: property)

  Whether to check if the resource is in the desired state by property (default) or using Invoke-DscResource in Test mode (resource).