SQL Server 2016 – Tempdb Configuration During Installation

After couple of years I’m started playing around the pre release packages. Today I installed Windows Server 2016 Technical preview release 3 and SQL Server 2016 CTP 2.4 in my machine to play around the upcoming release.

Almost the installation wizard is same as earlier version but there are two things which i found new.

  • Polybase Query Service for External Data

This allows SQL Server to query external polybase technologies including Hadoop. When you enable this it will create 3 new databases as shown below. We will discuss in later articles about these 3 new databases.


  • Tempdb Database Configuration during setup

As a DBA the first step after installing SQL Server is to setup as per the company policy and to deploy the best practices. In SQL Server 2016 installation I could see a seperate tab create in database configuration to configure tempdb databases. Cool!!

However I feel like instead of just providing the initial file size and number of files the wizard should analyze the existing core \ processors in the server and then it has to suggest the number of files and file sizes for tempdb database. This will be the appropriate method and the suggestion from the setup.. DBAs will be happy if they come up with some suggestions like that during setup.

Created a Connect ID. https://connect.microsoft.com/SQLServer/feedback/details/1921293/tempdb-files-configuration-suggestion. It will be great if you can vote for this so that they can add this functionality.


More SQL Server 2016 articles in queue!!

Leave a Reply

Leave a comment

Your email address will not be published. Required fields are marked *



Related Posts

Batch script to deploy multiple SQL files
I was working on a project where I’m supposed to deploy lots of SQL Server script files (.sql). It’s very tedious job either to manually execute ...
Installing SQL Server 2012
This might be a simple article for the intermediate folks, however I would like to show you the screen’s in SQL Server 2012 installation. As far ...
Installing SQL Server 2008 R2
In this article we are going to discuss about installing SQL Server 2008 R2, I know Im little late as R2 is released last month. Before we steppi...
powered by RelatedPosts