Setup Power Configuration

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:

Set Power Configuration using Regedit
Set Power Configuration using the Windows GUI

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

Open the Registry Editor by Start -> Run and type regedit
Navigate to HKLM\SOFTWARE\Policies\Microsoft\Power\PowerSettings

If any of these keys do not exist then create them.
If it does not already exist, create a new String Value called ActivePowerScheme
Set the value of ActivePowerScheme to the value below

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