Resource Type: dsc_sqlmemory

Properties

dsc_dynamicalloc

If set to ‘$true` then max memory will be dynamically configured. When this parameter is set to `$true`, the parameter MaxMemory must be set to `$null` or not be configured. Default value is `$false`.
dsc_ensure

When set to ‘’Present’‘ then min and max memory will be set to either the value in parameter MinMemory and MaxMemory, or dynamically configured when parameter DynamicAlloc is set to `$true`. When set to `’Absent’‘ min and max memory will be set to its default values. Default value is `’Present’‘.
dsc_isactivenode

Returns if the current node is actively hosting the _SQL Server_ instance.
dsc_maxmemory

Maximum amount of memory, in MB, in the buffer pool used by the instance of _SQL Server_.
dsc_maxmemorypercent

Maximum amount of memory, as a percentage of total server memory, in the buffer pool used by the instance of _SQL Server_.
dsc_minmemory

Minimum amount of memory, in MB, in the buffer pool used by the instance of _SQL Server_.
dsc_minmemorypercent

Minimum amount of memory, as a percentage of total server memory, in the buffer pool used by the instance of _SQL Server_.
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 Server_ 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).

Overview