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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.