tempdb Troubleshooting and Configuration

  • Benjamin Nevarez


tempdb is a system database used for holding temporary objects that can be user created or system created. Unlike other databases, tempdb is recreated every time SQL Server starts. The various uses of tempdb can be generally categorized into three groups: user, internal, and version store objects.


Hash Table Query Optimizer User Database Data Page User Object 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Benjamin Nevarez 2016

Authors and Affiliations

  • Benjamin Nevarez
    • 1
  1. 1.Santa ClaritaUSA

Personalised recommendations