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..
>
>
Showing posts with label dual. Show all posts
Showing posts with label dual. Show all posts
Sunday, February 19, 2012
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/tpcc_last_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..
>
>
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/tpcc_last_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..
>
>
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/tpcc_last_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..
>
>
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/tpcc_last_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..
>
>
AMD dual Core or Intel XEON
Hi
In our Office,We are building new server for SQL Server.
Presently we use that server for sql server 2000.
But in future (in 1 year) we will update to sql server 2005
The databases we use are for heavy transactional.
I have the following questions about which hardware to choose.
1.Is AMD dual Core processor GOOD
or
2.Intel xeon is good.
3.What factors we need to look into before deciding sql server hardware?
Any kind of help is greatly appreciated.
Thanks
Kumar
Kumar,
Might try this:
Dell's SQL Server 2000 Sizing Tool quickly and easily helps size your
database to find the right server and storage hardware for your
applications.
HTH
Jerry
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:757C4523-0D67-4777-A667-9ECC335F9323@.microsoft.com...
> Hi
> In our Office,We are building new server for SQL Server.
> Presently we use that server for sql server 2000.
> But in future (in 1 year) we will update to sql server 2005
> The databases we use are for heavy transactional.
> I have the following questions about which hardware to choose.
>
> 1.Is AMD dual Core processor GOOD
> or
> 2.Intel xeon is good.
> 3.What factors we need to look into before deciding sql server hardware?
>
> Any kind of help is greatly appreciated.
> Thanks
> Kumar
In our Office,We are building new server for SQL Server.
Presently we use that server for sql server 2000.
But in future (in 1 year) we will update to sql server 2005
The databases we use are for heavy transactional.
I have the following questions about which hardware to choose.
1.Is AMD dual Core processor GOOD
or
2.Intel xeon is good.
3.What factors we need to look into before deciding sql server hardware?
Any kind of help is greatly appreciated.
Thanks
Kumar
Kumar,
Might try this:
Dell's SQL Server 2000 Sizing Tool quickly and easily helps size your
database to find the right server and storage hardware for your
applications.
HTH
Jerry
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:757C4523-0D67-4777-A667-9ECC335F9323@.microsoft.com...
> Hi
> In our Office,We are building new server for SQL Server.
> Presently we use that server for sql server 2000.
> But in future (in 1 year) we will update to sql server 2005
> The databases we use are for heavy transactional.
> I have the following questions about which hardware to choose.
>
> 1.Is AMD dual Core processor GOOD
> or
> 2.Intel xeon is good.
> 3.What factors we need to look into before deciding sql server hardware?
>
> Any kind of help is greatly appreciated.
> Thanks
> Kumar
AMD dual Core or Intel XEON
Hi
In our Office,We are building new server for SQL Server.
Presently we use that server for sql server 2000.
But in future (in 1 year) we will update to sql server 2005
The databases we use are for heavy transactional.
I have the following questions about which hardware to choose.
1.Is AMD dual Core processor GOOD
or
2.Intel xeon is good.
3.What factors we need to look into before deciding sql server hardware'
Any kind of help is greatly appreciated.
Thanks
KumarKumar,
Might try this:
Dell's SQL Server 2000 Sizing Tool quickly and easily helps size your
database to find the right server and storage hardware for your
applications.
HTH
Jerry
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:757C4523-0D67-4777-A667-9ECC335F9323@.microsoft.com...
> Hi
> In our Office,We are building new server for SQL Server.
> Presently we use that server for sql server 2000.
> But in future (in 1 year) we will update to sql server 2005
> The databases we use are for heavy transactional.
> I have the following questions about which hardware to choose.
>
> 1.Is AMD dual Core processor GOOD
> or
> 2.Intel xeon is good.
> 3.What factors we need to look into before deciding sql server hardware'
>
> Any kind of help is greatly appreciated.
> Thanks
> Kumar
In our Office,We are building new server for SQL Server.
Presently we use that server for sql server 2000.
But in future (in 1 year) we will update to sql server 2005
The databases we use are for heavy transactional.
I have the following questions about which hardware to choose.
1.Is AMD dual Core processor GOOD
or
2.Intel xeon is good.
3.What factors we need to look into before deciding sql server hardware'
Any kind of help is greatly appreciated.
Thanks
KumarKumar,
Might try this:
Dell's SQL Server 2000 Sizing Tool quickly and easily helps size your
database to find the right server and storage hardware for your
applications.
HTH
Jerry
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:757C4523-0D67-4777-A667-9ECC335F9323@.microsoft.com...
> Hi
> In our Office,We are building new server for SQL Server.
> Presently we use that server for sql server 2000.
> But in future (in 1 year) we will update to sql server 2005
> The databases we use are for heavy transactional.
> I have the following questions about which hardware to choose.
>
> 1.Is AMD dual Core processor GOOD
> or
> 2.Intel xeon is good.
> 3.What factors we need to look into before deciding sql server hardware'
>
> Any kind of help is greatly appreciated.
> Thanks
> Kumar
AMD dual Core or Intel XEON
Hi
In our Office,We are building new server for SQL Server.
Presently we use that server for sql server 2000.
But in future (in 1 year) we will update to sql server 2005
The databases we use are for heavy transactional.
I have the following questions about which hardware to choose.
1.Is AMD dual Core processor GOOD
or
2.Intel xeon is good.
3.What factors we need to look into before deciding sql server hardware'
Any kind of help is greatly appreciated.
Thanks
KumarKumar,
Might try this:
Dell's SQL Server 2000 Sizing Tool quickly and easily helps size your
database to find the right server and storage hardware for your
applications.
HTH
Jerry
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:757C4523-0D67-4777-A667-9ECC335F9323@.microsoft.com...
> Hi
> In our Office,We are building new server for SQL Server.
> Presently we use that server for sql server 2000.
> But in future (in 1 year) we will update to sql server 2005
> The databases we use are for heavy transactional.
> I have the following questions about which hardware to choose.
>
> 1.Is AMD dual Core processor GOOD
> or
> 2.Intel xeon is good.
> 3.What factors we need to look into before deciding sql server hardware'
>
> Any kind of help is greatly appreciated.
> Thanks
> Kumar
In our Office,We are building new server for SQL Server.
Presently we use that server for sql server 2000.
But in future (in 1 year) we will update to sql server 2005
The databases we use are for heavy transactional.
I have the following questions about which hardware to choose.
1.Is AMD dual Core processor GOOD
or
2.Intel xeon is good.
3.What factors we need to look into before deciding sql server hardware'
Any kind of help is greatly appreciated.
Thanks
KumarKumar,
Might try this:
Dell's SQL Server 2000 Sizing Tool quickly and easily helps size your
database to find the right server and storage hardware for your
applications.
HTH
Jerry
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:757C4523-0D67-4777-A667-9ECC335F9323@.microsoft.com...
> Hi
> In our Office,We are building new server for SQL Server.
> Presently we use that server for sql server 2000.
> But in future (in 1 year) we will update to sql server 2005
> The databases we use are for heavy transactional.
> I have the following questions about which hardware to choose.
>
> 1.Is AMD dual Core processor GOOD
> or
> 2.Intel xeon is good.
> 3.What factors we need to look into before deciding sql server hardware'
>
> Any kind of help is greatly appreciated.
> Thanks
> Kumar
Subscribe to:
Posts (Atom)