Introduction

Energy efficiency is increasingly important in enterprise and data center environments, and it adds another set of tradeoffs to the mix of configuration options. When managing servers, it’s important to ensure that they are running as efficiently as possible while meeting the performance needs of their workloads. Windows Server is optimized for excellent energy efficiency with minimum performance impact across a wide range of customer workloads. Processor Power Management (PPM) Tuning for the Windows Server Balanced Power Plan describes the workloads used for tuning the default parameters in multiple Windows Server versions, and provides suggestions for customized tunings.

Problem

Check if the server is using the High Performance Power Plan

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_check_server_power_plan.sql

Example

Based on

https://blog.sqlauthority.com/2015/04/27/sql-server-using-high-performance-power-plan-for-sql-server/