Well, using perfmon I was able to see significant amounts of disk read and write on the SQL Box during these times... but I still didn't really know what that meant.
We've contracted a 4 hour block of time from a sql server tuning expoert and in conversations with him, just based on that information about, he suggested that we might have a problem with checkpoints, and it certainly seems to be that. I finally figured out how to enable the sql server counters in perfmon (we're running 32bit sql server 2000 on 64 bit windows server 2003 so the counters didn't appear in the 64 bit perfmon)... it does look like a checkpoint problem. I'll let the expert help us figure out the best way to resolve it but the solution may involve changing the server's recovery interval. Turns out that the physical hardware was ordered based on recommendations from seefusion. I'm surprised they'd recommend having the OS and Data on the same physical set of disks (maybe they didn't and the hosting company just misinterpreted their recommendations) but at least we have the transaction logs on their own set of disks. Anyway, as I get a complete answer from our consultant I'll report back here in case anyone googles similar issues or if anyone is just curious. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
