Operations That Heavily Stress Out TempDB/SQL Server

Written by belle
Posted July 23, 2008 at 10:23 pm

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

Rating: 0.0/10 (0 votes cast)

Rating: 0 (from 0 votes)

Be Sociable, Share!