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
No Comments
Filed under:
Issues/Troubleshooting