What is TempDB MDF used for?

Question

TempDB is used by the server for operations such as storing temporary and work tables, ordering records, storing records' versions, etc'. If the TempDB is growing, then the server needs more space in it. 20 янв. 2009 г.

What is the purpose of TempDB?

The tempdb system database is a global resource that holds: Temporary user objects that are explicitly created. They include global or local temporary tables and indexes, temporary stored procedures, table variables, tables returned in table-valued functions, and cursors.

Can I delete TempDB MDF?

All tempdb files are re-created during startup. However, they are empty and can be removed. To remove additional files in tempdb, use the ALTER DATABASE command by using the REMOVE FILE option. Use the DBCC SHRINKDATABASE command to shrink the tempdb database.

Why is TempDB MDF so large?

13 Answers. The mdf on tempdb will usually always be larger than the log file because most of the operations in tempdb aren't logged operations. Of course, tempdb is used for operations like large sorts and certain join functions (and of course temp tables 🙂 ).

Why TempDB is used in SQL Server?

Beyond just spills, SQL Server uses TempDB for a number of internal temporary objects, sorting for online re-indexing operations, multiple active result sets (MARS), along with version stores for data.

Expert · Answer