Examples/Resources/SqlServerMemory/1-SetMaxMemoryTo12GB.ps1
<#
.EXAMPLE This example shows how to set the minimum and maximum memory configuration option with the value equal to 1024 and 12288. #> Configuration Example { param ( [Parameter(Mandatory = $true)] [System.Management.Automation.PSCredential] [System.Management.Automation.Credential()] $SysAdminAccount ) Import-DscResource -ModuleName SqlServerDsc node localhost { SqlServerMemory Set_SQLServerMaxMemory_To12GB { Ensure = 'Present' DynamicAlloc = $false MinMemory = 1024 MaxMemory = 12288 ServerName = 'sqltest.company.local' InstanceName = 'DSC' PsDscRunAsCredential = $SysAdminAccount } } } |