This project has moved. For the latest updates, please go here.

Previous Configure SQL Instance Database Properties Manual Configuration Configure SQL Instance Permissions Properties Next

Configure SQL Instance Advanced Properties

FineBuild can Configure Advanced Properties of the SQL Server Instance.

The Advanced Properties for SQL Server need to be set to maximise SQL Server performance.

FineBuild Configure SQL Instance Advanced Properties

The SQL Instance Advanced Properties configuration relates to Process Id 5BD and is controlled by the parameters below:

Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupSQLInst FULL Yes Yes Yes Yes Yes
SetupSQLInst WORKSTATION Yes Yes Yes Yes Yes
SetupSQLInst CLIENT N/A N/A N/A N/A N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigSQLInst can also be used.

FineBuild also uses the following parameters to help configure SQL Advanced Properties:
Parameter Description
MaxDop Maximum degree of parallelism

The value for MaxDop is automatically calculated by FineBuild, or can be supplied as a parameter.

The default value for MaxDop is calculated by the following formula:
a) Divide the number of processors available to SQL Server by 1.5
b) Round the value up to the next highest integer
c) Cap the MaxDop value with a maximum of 8
Examples: If processors = 1, maxdop = 1. If processors = 4, maxdop = 3. If processors = 16, maxdop = 8
Top

Manual Configure SQL Instance Advanced Properties

The following steps show what you would have to do for manual SQL Instance Advanced Properties configuration. FineBuild does all of this work for you automatically.

1) Select the Advanced tab.
Set the following Advanced property:
Parameter Value
Max degree of parallelism Value calculated for MaxDop parameter

Advanced.png
2) Click OK to save any changes made.

Copyright © 2013 - 2014 Edward Vassie. License and Acknowledgements
Previous Configure SQL Instance Database Properties Top Configure SQL Instance Permissions Properties Next

Last edited Dec 22, 2014 at 4:53 PM by EdVassie, version 7