High Performance SQL Server: Consistent Response for Mission-Critical Applications

© Benjamin Nevarez 2021

B. NevarezHigh Performance SQL Serverhttps://doi.org/10.1007/978-1-4842-6491-1_4

4. tempdb Troubleshooting and Configuration

Benjamin Nevarez¹  

(1)

Santa Clarita, CA, USA

 

tempdb is a system database used for holding temporary objects that can be user 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.

1. a.

   User objects : Used for objects created directly by users like global and local temporary tables, table variables, or temporary stored procedures.

    
2. b.

   Internal objects : Used for internal objects including worktables to store temporary data for sorting, spools, and cursor ...