Operations That Heavily Stress Out TempDB/SQL Server
Operations that heavily stress out tempdb
These operations heavily use tempdb:
• Repeated create and drop of temporary tables (local or global).
• Table variables that use tempdb for storage purposes.
• Work tables associated with CURSORS.
• Work tables associated with an ORDER BY clause.
• Work tables associated with an GROUP BY clause.
• Work files associated with HASH PLANS.
Concurrency Enhancements for the TempDB database