Setup Power Configuration - SQL-FineBuild/Common GitHub Wiki

Previous Setup SSRS Service Timeout Manual Install Setup Windows Audit Next

FineBuild can set up the Windows Power Configuration to optimise performance for SQL Server.

Group Policy Management

The Setup Windows Power Configuration can be enforced by Group Policy Management.

FineBuild Power Configuration Processing

Automated processing of Power Configuration relates to Process Id 1CC in the FineBuild1Preparation script, and is controlled by the parameter below:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupPowerCfg: Yes No No
SQL2017 /SetupPowerCfg: Yes No No
SQL2016 /SetupPowerCfg: Yes No No
SQL2014 /SetupPowerCfg: Yes No No
SQL2012 /SetupPowerCfg: Yes No No
SQL2008R2 /SetupPowerCfg: Yes No No
SQL2008 /SetupPowerCfg: Yes No No
SQL2005 /SetupPowerCfg: Yes No No

The server is set to the High Performance power plan.

Setup of Power Configuration is not performed automatically for Workstation and Client build as these types of installations often have conflicting demands for power usage.

Top

Manual Setup Power Configuration Processing

The following steps show what you would have to do to setup Power Configuration manually. FineBuild does all of this work for you automatically.

This processing should always be performed for a Server Build, but may not be required for other types of build.

This processing can be completed using one of the options below:

The name of the High Performance power plan varies according to the version of Windows being used. However, the GUID of this plan is the same for all editions of Windows, and this is used in the example below.

Set Power Configuration using Regedit

  1. Open the Registry Editor by Start -> Run and type regedit

    Regedit Command

  2. Navigate to HKLM\SOFTWARE\Policies\Microsoft\Power\PowerSettings

    If any of these keys do not exist then create them.

    New Key

    Power Settings

  3. If it does not already exist, create a new String Value called ActivePowerScheme

    New String

    Power Scheme

  4. Set the value of ActivePowerScheme to the value below

    Max Power

    This value is the GUID for the High Performance power plan and is the same value in all versions of Windows.

  8c5e7fda-e8bf-4a96-9a85-a6e23a8c635c

Set Power Configuration using the Windows GUI

  1. The Power Configuration can be achieved from the Control Panel.

    Open Power Options and select the High Performance power plan

    High Performance

Copyright FineBuild Team © 2014 - 2018. License and Acknowledgements

Previous Setup SSRS Service Timeout Top Setup Windows Audit Next