Operations that heavily stress out tempdb

Excerpt:

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.

Source:

Concurrency Enhancements for the TempDB database
http://support.microsoft.com/default.aspx?scid=kb;en-us;328551

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)