SQL Server Performance Tuning

How a Windows Power Plan Made SQL Server Storage 10 Times Slower

Updated April 6, 20263 min read

A power plan made storage 10x slower. A race car stands on the track with its mode dial turned to the power-saving leaf.

Storage speed after the fix

10xRANDOM I/O (MIXED)
12.7xRANDOM READS
56xRANDOM WRITES

Slow storage makes every query slow.

Sometimes the storage is slow for a reason that has nothing to do with the disks.

Problem

Data files were taking 100 to 565 ms to respond while the server moved only 7 MB per second. Queries that used to be fast suddenly took longer, and nothing in the code had changed.

The storage team said everything was fine. But those numbers said otherwise.

You do not expect high latency under almost no load from tier 1 storage. Anything above 20 ms is already a problem.

Solution

First we measured the storage with CrystalDiskMark, a free disk benchmark tool (64 GiB test file, 70% read and 30% write mix) to get a baseline. Then we looked for the cause.

The cause was the Windows power plan. The server was running on the default Balanced plan, which slows the CPU down to save power. That slows I/O processing too.

This is what we did to fix the issue: we changed the power plan to High performance and ran the same test again.

Before vs. After

Random 4K throughput went from 33 MB/s to 336 MB/s on the same disks.

Random 4K, queue depth 32, 16 threadsBefore (Balanced)After (High performance)Improvement
Mixed 70/30 (MB/s)33.07336.3810.2x
Read (MB/s)25.94329.1012.7x
Write (MB/s)6.07342.6956x
Read IOPS6,33380,34612.7x
Read latency (ms)79.46.412.4x
Measured with CrystalDiskMark. Random 4K with many threads is the pattern closest to an active OLTP server.

Sequential speed improved too, from 510 MB/s to 1,532 MB/s for reads.

The server and the storage were the same in both tests. Only the power plan changed.

Final thoughts

Check the power plan on every database server. Balanced is the Windows default, and it is the wrong setting for SQL Server.

It takes a minute to check and a minute to fix, and we still find it on production servers during health checks.

Before you blame the SAN or buy faster disks, look at your operating system settings.

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 ➜