TempDB in SQL Server 2016

If you have been installing and configuring SQL Server 2016, you know there are some changes in the default settings when creating your TempDB. These settings are fairly simple, and can be reviewed here.

TempDB datafiles

Setting Default Value
Number of files The default value is the lower of 8 or the number of logical cores detected by setup.
Initial size  8 MB
Auto-growth 64 MB
Data directories Default data directory: C:\Program Files\MicrosoftSQL Server\MSSQL13.<InstanceID>\MSSQL\Data

TempDB logfile

Setting Default Value
Initial size 8 MB
Auto-growth 64 MB
Log directory Default data directory: C:\Program Files\MicrosoftSQL Server\MSSQL13.<InstanceID>\MSSQL\Data
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s