How Many tempdb Data Files Should My SQL Server Have?

July 2, 2019

We’re frequently asked how many tempdb files a SQL Server should have, especially from those who have downloaded our free 5 Common SQL Server Configuration Issues PDF. That’s because there’s a lot of well-intended but incorrect information posted on the internet about tempdb.  What Is tempdb? Let’s start with a very brief description of tempdb. When SQL…
Read more