Tempdb Archives - SolarWinds

SQL Server Internals: Tempdb Part 1

SQL Server Internals: Tempdb Part 2 SQL Server has been around for over 30 years, and I’ve been working with SQL Server for almost as long. I’ve seen a lot of changes over the years (and decades!) and versions of this incredible product. In these posts I’ll share with you how I look at some […]

Unlearn 2 Trace Flag which would not work with SQL Server 2016

Trace flag are switches in SQL Server, which would change the behavior of the SQL Engine. In developer terms they are like “if” clauses in the SQL Server code. If a trace flag is enabled, then certain behavior would change. One of the common trace flag which would be known to almost all DBAs and […]

Tempdb tuning Out-of-the-Box with SQL Server 2016

I have always felt that to have a perfectly tuned tempdb, we are supposed to have a number of traceflags and tuning. For many of my DBA friends, this conversation is no brainer. They create multiple files once they get into tempdb contention. I always felt this could have been automated as part of the […]

3 Things You Might Not Know About SQL Server TempDB and Performance

SQL Server has four system databases by default and one of them is called TempDB. TempDB is used for many operations, such as user-created temporary objects, internal temporary objects and version stores and certain features like online re-indexing, multiple active record sets (MARS) and others. Since TempDB is shared across all databases and all connections in SQL […]

Cause of SQL Server performance issue: maybe it’s tempDB?

When it comes to building software, our end users are the key to what we build. Most developers and project managers will focus on the use cases are for their software. So whatever is done, it is seen from the eye of the user. Likewise, when a database professional gets deployed into a customer location, they may hear comments from […]