PowerPlan

Get-DbaPowerPlan

Chrissy LeMaire (@cl), netnerds.net

Get-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves Windows Power Plan configuration from SQL Server hosts to verify High Performance settings. Description 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.

Set-DbaPowerPlan

Chrissy LeMaire (@cl), netnerds.net

Set-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Configures Windows power plan on SQL Server host computers to optimize database performance. Description Changes the Windows power plan on SQL Server host machines using WMI and PowerShell remoting. Defaults to High Performance, which prevents CPU throttling that can severely impact database query performance and response times.

Test-DbaPowerPlan

Chrissy LeMaire (@cl), netnerds.net

Test-DbaPowerPlan View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Tests Windows Power Plan settings against SQL Server best practices and identifies non-compliant systems. Description Audits Windows Power Plan settings on SQL Server hosts to ensure compliance with Microsoft’s performance recommendations. SQL Server runs optimally with the “High Performance” power plan, which prevents CPU throttling and ensures consistent performance under load.