Examples/Resources/xSQLServerMemory/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 xSqlServer node localhost { xSQLServerMemory Set_SQLServerMaxMemory_To12GB { Ensure = 'Present' DynamicAlloc = $false MinMemory = 1024 MaxMemory = 12288 SQLServer = 'SQLServer' SQLInstanceName = 'DSC' PsDscRunAsCredential = $SysAdminAccount } } } |