Tag: TempDB

SQL Server upgrade time

End of Mainstream Support for SQL Server 2016

The end of Mainstream Support. Is that really as dire as it sounds? Because it sounds like I’ll be completely on my own. No support. At least no “mainstream” support, whatever that means. What happens if something goes wrong?

money to buy more SQL Server resources

Should I Add Hardware Resources to My SQL Server? Do This First.

“The server is seriously slow! Can’t we add memory or something?” We’ve all heard this before. You may have even thought it yourself. Adding resources could be an easy fix to a troublesome performance problem. After all, SQL Server hungers for memory. The more the better. And a side of processor goes a long way,…
Read more

Stop doubting your sql server environment

Five Goals for Your SQL Servers in the New Year

We’ve made it! The start of a new year. Now is a great time to reflect on what you’d like to accomplish over the next 12 months at work, and more specifically, what you would like to do with your SQL Server environment this year. To help with that, here are five activities or goals…
Read more

Let's count the number of SQL Server tempdb files I have

3 Ways to Find Your SQL Server tempdb Data Files

Checking the number of tempdb data files is straightforward. Here are three easy ways: one graphical, one T-SQL, and one PowerShell, so you can use your tools of choice.

How Many tempdb Data Files Should My SQL Server Have?

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

“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