Author | Chrissy LeMaire (@cl), netnerds.net |
Availability | Windows, Linux, macOS |
Want to see the source code for this command? Check out Get-DbaPowerPlan on GitHub.
Want to see the Bill Of Health for this command? Check out Get-DbaPowerPlan.
Retrieves Windows Power Plan configuration from SQL Server hosts to verify High Performance settings.
Checks the active Windows Power Plan configuration on SQL Server host computers to ensure they follow performance best practices. SQL Server performance can be significantly impacted by power management settings that throttle CPU frequency or put processors to sleep during idle periods.
By default, returns the currently active power plan for each specified computer. Use the -List parameter to view all available power plans and their status. Microsoft recommends using the "High Performance" power plan for SQL Server hosts to prevent CPU throttling and ensure consistent database performance.
Get-DbaPowerPlan
[-ComputerName] <DbaInstanceParameter[]>
[[-Credential] <PSCredential>]
[-List]
[-EnableException]
[<CommonParameters>]
PS C:\> Get-DbaPowerPlan -ComputerName sql2017
Gets the Power Plan settings for sql2017
PS C:\> Get-DbaPowerPlan -ComputerName sql2017 -Credential ad\admin
Gets the Power Plan settings for sql2017 using an alternative credential
PS C:\> Get-DbaPowerPlan -ComputerName sql2017 -List
Gets all available Power Plans on sql2017
Specifies the SQL Server host computer(s) to check for Windows Power Plan configuration. Accepts multiple server names for bulk power plan auditing.
Use this to verify that your SQL Server hosts are configured with the recommended "High Performance" power plan instead of "Balanced" or "Power Saver" modes that can throttle CPU performance.
Alias | |
Required | True |
Pipeline | true (ByValue) |
Default Value |
Specifies a PSCredential object to use in authenticating to the server(s), instead of the current user account.
Alias | |
Required | False |
Pipeline | false |
Default Value |
Returns all available power plans on the target computers instead of just the currently active plan. Shows the status of each plan including which one is active.
Use this when you need to see all power plan options available on a server before making configuration changes or to audit power plan availability across your environment.
Alias | |
Required | False |
Pipeline | false |
Default Value | False |
By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.
Alias | |
Required | False |
Pipeline | false |
Default Value | False |