O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 43. How to optimize tempdb performance

Brad M. McGehee

Although most DBAs know about the tempdb database, many seem to think of it as a black box that takes care of itself with no involvement required from the DBA. Although this may be true on smaller, less active SQL Server instances, tempdb can significantly affect SQL Server’s performance. DBAs can act to ensure that tempdb performance is optimized and to optimize the overall performance of SQL Server.

What is tempdb used for?

The tempdb database is one of SQL Server’s included system databases and is used as a shared temporary workspace for many different kinds of activities, such as the following:

  • Storing user objects, such as temporary local and global tables and indexes, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required