Databases Reference
In-Depth Information
8
Knowing Tempdb
WHAT'S IN THIS CHAPTER?
➤
How SQL Server uses tempdb for internal and user-created
temporary objects
➤
Avoiding and troubleshooting common tempdb issues
➤
How to monitor and tune tempdb performance
➤
Using confi guration best practices to increase the performance and
availability of tempdb
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
The
wrox.com
code downloads for this chapter are found at
http://www.wrox.com/
remtitle.cgi?isbn=1118177657
on the Download Code tab. The code is in the Chapter 8
download and individually named according to the names throughout the chapter.
INTRODUCTION
This chapter is about the system database called tempdb, which is used for storing temporary
objects and has been a key component of SQL Server since its inception. Beginning with SQL
Server 2005, however, the role of tempdb has been brought to the forefront with a plethora of
new features and optimizations that depend on temporary objects.
All these features have increased the visibility and requirement for good tempdb performance,
which is why we have dedicated a full chapter to a thorough grounding in what it is used for,
how to troubleshoot issues, and how it should be coni gured.
Search WWH ::
Custom Search