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

Previous Configure SQL Instance Memory Properties Manual Configuration Configure SQL Instance Security Properties Next

Configure SQL Instance Processor Properties

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 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:

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.
Top

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.

1) Select the Processors tab.
The Processors properties are not normally changed from the default values shown.
Processor.png
2) Click OK to save any changes made.

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

Last edited Jun 19, 2014 at 7:22 PM by EdVassie, version 5