Configure SQL Instance Properties - SQL-FineBuild/Common GitHub Wiki
| Previous Configure SQL Mail | Manual Configuration | Configure SQL Instance General Properties Next |
|---|
FineBuild can Configure the Properties available in SSMS for the SQL Server Instance.
The operation of the SQL Server instance is controlled by a number of properties. Some of these need to be set to obtain maximum performance and stability. The propertiies available on each of the Tabs on the SSMS Instance Properties dialogue are dealt with separately.
| Item | Comment |
|---|---|
| Configure SQL Instance General Properties | Review general configuration for SQL Server |
| Configure SQL Instance Memory Properties | Configure optimum memory allowed for SQL Server |
| Configure SQL Instance Processor Properties | Review processor configuration for SQL Server |
| Configure SQL Instance Security Properties | Configure auditing of SQL Logon activity |
| Configure SQL Instance Connection Properties | Review client connection configuration for SQL Server |
| Configure SQL Instance Database Properties | Configure database locations for SQL Server |
| Configure SQL Instance Advanced Properties | Configure optimum maximum parallelisation for queries |
| Configure SQL Instance Permissions Properties | Configure fine-grained permissions |
FineBuild Configure SQL Instance 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.
FineBuild will automatically perform Instance Properties configuration for each of the Items given above.
Manual Configure SQL Instance Properties
The following steps show what you would have to do for manual SQL Instance Properties configuration. FineBuild does all of this work for you automatically.
-
Use SQL Server Management Studio to connect to the SQL instance
Right-click on the instance and select Properties
-
Perform Instance Properties configuration for each of the tabs given above
Copyright FineBuild Team © 2013 - 2019. License and Acknowledgements
| Previous Configure SQL Mail | Top | Configure SQL Instance General Properties Next |
|---|