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 ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.