I have two servers both running SQL Server 2000 and both with an identical database loaded. Both servers have 2.5 Gb memory, one with twin 1.4 Ghz P4 processors and one with twin 933Mhz P3 processors. The same query run against each server gives results back in 10 secs on the slower machine and sub second on the faster. Can this huge difference in response be explained by the different processors, or should I keep looking for configuration etc? Note that on the slower machine, the extra processor was loaded after SQL Server had been installed, but the properties of both machines show that all processors are enabled.