I think it's a combination of explicit and implicit tempDB usage. A while ago, the DBA's showed the developers the magic of using staging tables in their procs, and...

it's pretty much a single purpose database and it has crazy numbers on the write waits on the tempdb and high workfile numbers.

ed

yeah, I have access to the SP's, so I can see all the tempdb creations. The other tempDB usage (spools, aggregations) may also be a problem.

Ideally, I would like...