Set-sqmMaxDop - sqmSQLTool PowerShell Cmdlet Documentation

Set-sqmMaxDop

SQL Config sqmSQLTool v1.8.2+

Sets MAXDOP (max degree of parallelism) to the recommended (or an explicit) value, and optionally the matching "cost threshold for parallelism".

Examples

Set-sqmMaxDop -SqlInstance SQL01

Set-sqmMaxDop -SqlInstance SQL01
    Sets MAXDOP to min(8, CPUs) and cost threshold to 50.

Set-sqmMaxDop -SqlInstance SQL01 -MaxDop 4 -SkipCostThreshold

Set-sqmMaxDop -SqlInstance SQL01 -MaxDop 4 -SkipCostThreshold
    Sets MAXDOP to 4, leaves the cost threshold unchanged.

Set-sqmMaxDop -SqlInstance SQL01 -WhatIf

Set-sqmMaxDop -SqlInstance SQL01 -WhatIf
    Shows the planned MAXDOP/cost-threshold change without applying it.