SQL SERVER – New features in SQL Server 2016 Setup Wizard

In this world of change, the SQL Server product is also changing. One thing which is very clear is that Microsoft is listening to feedbacks from customers and enhancing the setup experience also. Some of the classic feedback implementation can be seen in the setup of the next version of SQL Server 2016. In this blog post, I will try to bring out some of the enhancements that are being incorporated in the Setup UI. Some are critical and worth making a note. Let us learn about SQL Server 2016 Setup Wizard.

Here are the few things which I noticed in SQL Server user interface.

SQL Setup allows user to add Database Engine Service SID into “Perform Volume Maintenance Task” privilege under security policy. This helps in instant file initialization

SQL SERVER - New features in SQL Server 2016 Setup Wizard sql2016-setup-01

Solarwinds

Here is the new parameter added in command line for SQL Setup.

SQLSVCINSTANTFILEINIT=”True”

This may lead to information disclosure as it could allow deleted content to be accessed by an unauthorized principal.

TempDB Configuration

In SQL Server 2016, we have the option to specify TempDB file specifications during setup itself. Most of the companies have “post deployment script” and one of the steps is to optimize TempDB files. It’s a tab called “TempDB” under “Database Engine Configuration”

SQL SERVER - New features in SQL Server 2016 Setup Wizard sql2016-setup-02

Since UI has it, there is also a parameter in command line as below:

ParameterMeaning
SQLTEMPDBFILECOUNTThe number of Database Engine TempDB files
SQLTEMPDBFILESIZEInitial size of a Database Engine TempDB data file in MB.
SQLTEMPDBFILEGROWTHautomatic growth increment of each Database Engine TempDB data file in MB
SQLTEMPDBLOGFILESIZEinitial size of the Database Engine TempDB log file in MB.
SQLTEMPDBLOGFILEGROWTHautomatic growth increment of the Database Engine TempDB log file in MB.
SQLTEMPDBDIRDirectories for Database Engine TempDB files.
SQLTEMPDBLOGDIRDirectory for the Database Engine TempDB log files

Hopefully, we would see more feedback embedded in the product by default.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , ,
Previous Post
Interview Question of the Week #046 – How @@DATEFIRST and SET DATEFIRST Are Related?
Next Post
SQL SERVER – What Resource Wait Are We Seeing?

Related Posts

4 Comments. Leave new

Leave a Reply

Menu