Hi all, First I must say this is both a great site & forum, I've learned plenty from here. Anyway onto my problem: I've just purchased a brand new server to replace an existing SQL server: Dell Poweredge 1800 2 X Xeon 3.2Ghz - HTT disabled 2 GB RAM 4 X U320 HDD RAID 0 Array. Running Windows 2003 (member server), Dedicated to running SQL 2000. I'm a little disappointed with the results I'm receiving, in particular one job. Converting data from our old Dos application, to our new Windows system (dos database, to SQL database). In case you need to know the conversion process is carried out by a VB6 application designed by our developers. Anyway it turns out that a notebook computer here is able to carry out the conversion process in roughly the same time (3hrs 10 mins), but has a far worse spec: Mobile 1.5ghz processor 256mb RAM IDE HDD. I've read up as many performance tuning articles as I possibly could but have not been able to make a single difference to the new server. I've tried the following: Disabling HTT - did speed up the conversion process by around 15 mins. Setting the degree of parallelism to 1 - Slowed down the conversion process. Within the Processor controll area setting SQL to only use one processor - again slowed down the process. Various other things like setting the max worker threads lower. I've carried out a performance monitor and the only difference between the two machines is that the notebook mostly has the CPU maxed out, where as the server average's around 50% for both processors. Please note, I'd like to think the test I'm carring out is fair. I'm using the same data, and conversion app on both machines, and carrying out the testing when the server isn't in use. Only difference is the OS and the notebooks running MSDE 2000. Any tips on what I should be looking into would be greatly appreciated.