Configure SQL Instance Processor Properties - SQL-FineBuild/Common GitHub Wiki
| Previous Configure SQL Instance Memory Properties | Manual Configuration | Configure SQL Instance Security Properties Next |
|---|
FineBuild can Configure the Processor Properties available in SSMS for the SQL Server Instance.
The SQL Instance Processor Properties do not normally need to be altered.
For systems with 8 or more processor cores, performance can be improved by setting processor affinity. Setting CPU affinities for SQL Server, I-O and network is an advanced topic beyond the scope of SQL FineBuild. If you have more than 8 processor cores, you should research this issue in detail before any affinity settings are made.
FineBuild Configure SQL Instance Processor Properties
The SQL Instance 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.
Manual Configure SQL Instance Processor Properties
The following steps show what you would have to do for manual SQL Instance Processor Properties configuration. FineBuild does all of this work for you automatically.
-
Select the Processors tab
The Processors properties are not normally changed from the default values shown
-
Click OK to save any changes made
Copyright FineBuild Team © 2013 - 2020. License and Acknowledgements
| Previous Configure SQL Instance Memory Properties | Top | Configure SQL Instance Security Properties Next |
|---|