Does anyone have any logical explaination why the same database SELECT query would run much faster on a Inten XEON W3503 than an AMD Opteron 2425 HE (six core) processor? Even when there are only logical reads (reads to cache). Do the AMD processors run on a much slower bus? Does anyone have any idea?
With pretty much any SQL database, if you just have the one process running your bottleneck is disk I/O and NOT cpu cycles.
I think if you check the specs on the machine you will find one of the following:
There are so many configuration options that affect the speed of SQL Server, it's almost impossible to compare apples to apples unless you copy EVERYTHING between machines.
Found two links in MS KB regarding issues with AMD processors (one specifically with the opteron):
Both are related to the time stamping function.