MSQL 7 runs slower on a dual Xeon then on a Pentium 3
Posted on 2004-03-21
2 - gigs of Kingston ram
2 - 2.6 Intel Xeon processors
Mother board Intel Server Board SE7500CW2
Running SQLserver, 7.00.623, MS 2000 server, IIS
Query's with complex joins and subquerrys are running at the same speed and slower then on a single processor exact same software configuration p3 with 500 megs of ram (the only difference software wise between the P3 and the dual xeon is that the p3 is running MS 2000 Advanced Server and does not use raid). However the P3 has the exact same config relating to Data, IIS and MSQL all running on the same machine and off the same hard drive.
Another comparison machine that we have is a single P4 1.8 ghz 1 gig of ram using the same raid configuration running MS 2000 server, IIS and Oracle that is running similar query's approximately 100% faster then the dual Xeon (this machine allso has everything on the same drive).
We have run tests on all aspects of the machine it does help a small amount if we set up SQL server to use only one CPU but still performance is slower then the P3 or P4.
Tests that have been run include hardrive tests, load tests, sql workload tests. The hardrive tests have proven to be the only thing that performs at the level expected.
I have checked the disk queue length and it is under 2.
In addition all database level performance issues have been addressed including rebuilding indexes etc.
Tests have been performed with Hyperthreading enabled and disabled with negligible difference in performance.
I have not experimented with puting the dbs on a differnt drive becuase the comparison machines are running fine with everything on the same machine and drive.