Tag: Database Administration

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

Why 9 Out of 10 SQL Servers Aren’t Configured with Best Practices

June 6, 2018

“The nice thing about standards is that you have so many to choose from,” quipped renown computer scientist Andrew Tanenbaum. In the SQL Server world, we have industry best practices. These are guidelines that most every knowledgeable database professional will agree is a good idea or a good baseline. Sure there are exceptions, specific tweaks…
Read more

Subscribe to Blog

TAGS
Recent
Database Administration
Script Library

2000 Mallory Lane
Suite 130-707
Franklin, TN 37067

© 2024 The SERO Group.