Examples/Resources/xSQLServerConfiguration/2-ConfigureInstanceToEnablePriorityBoost.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<#
.EXAMPLE
    This example shows how to configure two SQL Server instances on the same server to have the setting 'priority boost' enabled.
.NOTES
    To get all available options run sp_configure on the SQL Server instance, or refer to https://msdn.microsoft.com/en-us/library/ms189631.aspx
#>


Configuration Example
{
    Import-DscResource -ModuleName xSqlServer

    node localhost
    {
        xSQLServerConfiguration 'SQLConfigPriorityBoost'
        {

            SQLServer       = 'localhost'
            SQLInstanceName = 'MSSQLSERVER'
            OptionName      = 'priority boost'
            OptionValue     = 1
            RestartService  = $false
        }
    }
}