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?
Geo.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart