The new CTP 2.4 has been released and announced by Microsoft in its blog post a couple of days ago. During my investigation, I noticed some new installer capabilities about the tempdb database. As a reminder, you can read my first thoughts from my blog post here, but to be short, the installer was able to provide automatically the right…
In my first blog about SQL Server 2016, I noticed during the SQL Server installation process that we are able to configure the number of files for tempdb. This is surely a great improvement but at this point, you may think that the configuration of the tempdb database is finished but in fact you’re wrong. Let me say why. First…
A couple of weeks ago, I had an interesting discussion with one of my friend that faced a weird issue with a SQL Server instance that lacked worker threads. Because I can’t use his own information I decided to reproduce the same issue in order to share with you some interesting information. So the next part of this blog post…
SQL Server 2014 is definitively designed for performance and I will try to demonstrate it during this blog post. I like to talk about hidden performance features because generally it does not require any changes for applications unlike in-memory tables for instance (aka hekaton tables). Since SQL Server 2005 version some improvements have been made for tempdb. Tempdb caching is…
