SQL Server Health Check

Disabling Windows “Visual Effects” to Boost Performance

Updated October 29, 20252 min read

Windows visual effects on a server: Ploom unimpressed by a disco-ball server cabinet

Windows visual effects are not optimal

By default, Windows is optimized for a beautiful display, but this is not very important for a server.

These visual effects may cause a virtual machine to appear to run slower.

They are not required and consume CPU resources that would be spent on your SQL Server tasks.

So, disable the visual effects to get a slight performance increase

How to adjust the Windows visual effects for best performance:

  1. Go to the Advanced tab in the System Properties dialog.
  2. Select the Performance Options dialog by clicking Settings in the Performance panel.
  3. In the Performance Options dialog, select the Visual Effects tab.
  4. Select "Adjust for best performance".
Figure 1 – Visual Effects tab
Figure 1 – Visual Effects tab
  1. In the Advanced dialog, on "Adjust for best performance of", choose "Background services".
Figure 2 – Adjust for best performance of "Background services"
Figure 2 – Adjust for best performance of "Background services"

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 ➜