#t1117

SQL Server 2016 TempDB Changes

With the upcoming release of SQL Server 2016, one thing you need to understand is the changes to the way TempDB works. One goal of this new release is “Out of the box” optimization so an administrator should not have to engage in TempDB tuning exercises or tweaking efforts.   

TEMPDB

One of these important changes is TEMPDB always assumes -T1117 and -T1118 behavior.

-T1117 – When growing a data…

Recommended Configuration Options for SQL Server

Sometimes your environment is unique enough that the standard recommendations aren’t enough to address your SQL Server performance needs. Your high performance environment might need a tweak to get a little more performance, but the good news is you are not alone. The Microsoft technical team has worked though problems like yours and has some basic recommendations. You can access the specifics…