SQL Server Health Check

Best Windows Power Plan for Optimizing SQL Server Performance

Updated October 29, 20251 min read

Windows power plan for SQL Server. Ploom frowns at a big dial set to the leaf side, beside a dim server cabinet.

CPU performance and Windows power plans

Usually, the balanced power plan is set by default, which is what Microsoft recommends for general use.

Great for saving the planet and being green, but it can be terrible for server performance.

The benefit of setting the server power management to high performance is for SQL Server to have consistent, predictable and high performance.

How to identify the issue?

On Windows Server 2008 and above, you can access the Power Options screen by typing powercfg.cpl in a Run prompt.

Figure 1 - Options of Windows power plans
Figure 1 - Options of Windows power plans

How do I fix it?

  1. Set Windows power plan to High performance.
  2. Validate BIOS power management is disabled or set to OS control.

More information

Check Red9's SQL Server Services

SQL Server Consulting

Perfect for one-time projects like SQL migrations or upgrades, and short-term fixes such as performance issues or SQL remediation.

Discover More ➜

SQL Server Managed Services

Continuous SQL support, proactive monitoring, and expert DBA help with one predictable monthly fee.

Discover More ➜

Emergency SQL Support

Take the stress out of emergencies with immediate access to a SQL Server Sr. DBA 24x7x365

Discover More ➜

Explore All Services ➜