AMDs or Intels..

With all the latest in dual cores and quad cores and 2 sockets and 4
sockets, has anyone done any hard core test say on an Intel 2 socket dual
core vs AMD 2 socket dual core and can really tell if SQL is faster on one
than the other.
Also if one has done some tests on HP or Dell. Curious to find out..Typically Disk throughput is your bottleneck in SQL Server OLTP. Spend your
primary budget a bigger/faster disk subsystem. Then spend on memory.
As far as CPU's are concerned; Buy the ones with the larger L2 and L3 on-die
cache.
"Hassan" <hassan@.hotmail.com> wrote in message
news:%23w2EGcnRHHA.3412@.TK2MSFTNGP05.phx.gbl...
> With all the latest in dual cores and quad cores and 2 sockets and 4
> sockets, has anyone done any hard core test say on an Intel 2 socket dual
> core vs AMD 2 socket dual core and can really tell if SQL is faster on one
> than the other.
> Also if one has done some tests on HP or Dell. Curious to find out..
>|||Hassan wrote:
> With all the latest in dual cores and quad cores and 2 sockets and 4
> sockets, has anyone done any hard core test say on an Intel 2 socket dual
> core vs AMD 2 socket dual core and can really tell if SQL is faster on one
> than the other.
> Also if one has done some tests on HP or Dell. Curious to find out..
>
Check TPC, most recently publiched TPC-C results
(http://www.tpc.org/tpcc/results/tpc...ten_results.asp). HP has some
AMD and Intel based servers there.
Arto Viitanen, CSC Ltd.
Espoo, Finland|||Check tthis out: Some interesting comparision Charts
http://www23.tomshardware.com/cpu.html
Maninder
MCDBA|||The infrastructure engineering group of any large enterprise would be remiss
in its duties if this sort of tests are not done internally. But the result
of such a study is almost always for internal consumption only and is rarely
published.
Linchi
"Hassan" wrote:

> With all the latest in dual cores and quad cores and 2 sockets and 4
> sockets, has anyone done any hard core test say on an Intel 2 socket dual
> core vs AMD 2 socket dual core and can really tell if SQL is faster on one
> than the other.
> Also if one has done some tests on HP or Dell. Curious to find out..
>
>