Most of it seems to be disk activity. The cpu never goes much over 10% usage
and it never maxes out the memory either. But the whole time it's beating
crap out of my disks.
How big is your tempdb? Also, since switching to SQL7 I have not figured out
how to put tempdb in RAM like I did on SQL 6.5, is there a way to do that?
For more information about this list (including removal) go to: