Configure SQL Instance Advanced Properties - SQL-FineBuild/Common GitHub Wiki
| Previous Configure SQL Instance Database Properties | Manual Configuration | Configure SQL Instance Permissions Properties Next |
|---|
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:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2017 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2016 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2014 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2012 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2008R2 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2008 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2005 | /SetupSQLInst: | Yes | Yes | 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:
- Divide the number of processors available to SQL Server by 1.5
- Round the value up to the next highest integer
- 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
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.
-
Select the Advanced tab
Set the following Advanced property:
Parameter Value Max degree of parallelism Value calculated for /MaxDop: parameter 
-
Click OK to save any changes made
Copyright FineBuild Team © 2014 - 2020. License and Acknowledgements
| Previous Configure SQL Instance Database Properties | Top | Configure SQL Instance Permissions Properties Next |
|---|