O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

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

Configuring the tempdb database on separate physical disk

The tempdb database is one of the system databases of SQL Server that is essential for its normal functioning. SQL Server relies on the tempdb database to perform many of its operations and stores internal objects in this database. The following are some of the operations for which the tempdb database is used by SQL Server:

  • Performing grouping or sorting operations in queries
  • Cursor operations
  • Version store operation
  • Online index creation
  • Storing intermediate results in worktables
  • Storing user objects, such as local or global temporary tables and table variable data

The tempdb database is the central database for all the databases and applications per the SQL Server instance. Therefore, if many ...

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