Query runs slower on newer server

[sqlwp]

I am in the process of moving my sql database to a newer server(Windows 2003, SQL 2000) from (NT/SQL 7.0). The server has 2 more processor and more memory. My update queries are taking twice as long to run on the new server. It doesn't look like it's using the processors, it seems like it is all i/o. Is there a configuration setting I need to check somewhere?

 

[donutman]

After upgrading my OS from W2k to W2003 while using SQL 2K, I was forced to revert the OS back to W2K. All my linked server operations gave me a "Non-interface error: CoCreate of DSO for Jet..." error. I scoured the net for an answer. Similar errors have been reported, but no solution offered.
I know this doesn't have much to do with your problem, but just thought I'd mention it here for others considering an upgrade.
-Karl

[red] Cursors, triggers and user-defined functions are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[sqldev1]

If server is configured with hyperthreading, turn it off and check the performance. This has caused me several problems with large sql databases. I believe MS has posted some known problem documentmentation dealing with this.