quad datawarehouse server

[ray2]

why only comparison between dual opteron and dual xeon.

what about dual power5 and dual itanium 2? because our datawarehouse environment is 20 fold bigger and we run 4 cpu xeon MP 3.0 Ghz and we looking for doubling our performance for $50K budget. We have 60 disks 73 GB 10k rpm fibre connected to IBM FastT900.

on real terms, we are looking for 6-7 times more performance than your 2 cpu tests on 4 cpu machine.

the only machine which seems to fit the bill is power 5 1.9 Ghz but cost including three dual gigabit ethernet, six 2 Gbps HBA's and 20 GB memory is costing us $100K.

I feel for the price/performance of a quad 1.9 Ghz power 5 (AIX 5.3L) Vs quad opteron 852 (Solaris 10) Vs 1.5 Ghz HP-UX 11ir2, looks like opteron should be $50-55K, Itanium $60-65K and Power 5 1.9 Ghz $70-75K.

I have only considered 64 bit OS and I beleive windows server 2003 and linux 2.6 kernel are not as robust or time tested. Same thing can be said for Solaris 10 and hence most likely I will go for itanium or power 5 if the vendors drop the prices by $25K or so to be more in line to my target.

 

[LikeLinus]

Originally posted by: ray2
why only comparison between dual opteron and dual xeon.

what about dual power5 and dual itanium 2? because our datawarehouse environment is 20 fold bigger and we run 4 cpu xeon MP 3.0 Ghz and we looking for doubling our performance for $50K budget. We have 60 disks 73 GB 10k rpm fibre connected to IBM FastT900.

on real terms, we are looking for 6-7 times more performance than your 2 cpu tests on 4 cpu machine.

the only machine which seems to fit the bill is power 5 1.9 Ghz but cost including three dual gigabit ethernet, six 2 Gbps HBA's and 20 GB memory is costing us $100K.

I feel for the price/performance of a quad 1.9 Ghz power 5 (AIX 5.3L) Vs quad opteron 852 (Solaris 10) Vs 1.5 Ghz HP-UX 11ir2, looks like opteron should be $50-55K, Itanium $60-65K and Power 5 1.9 Ghz $70-75K.

I have only considered 64 bit OS and I beleive windows server 2003 and linux 2.6 kernel are not as robust or time tested. Same thing can be said for Solaris 10 and hence most likely I will go for itanium or power 5 if the vendors drop the prices by $25K or so to be more in line to my target.

I doubt they have vendors just throwing 60K boxes at them to test. Why not just search for the results independently based on CPU architecture and consider their performance chip vs chip and platform vs platform...then go from there. They're not going to do a specialized review just for you. As an IT person with a budget that large..you should know how to research and pick accordingly.

 

[ray2]

We want to atleast half our datawarehouse query time.

if we succeed we replicate the same database config on our other 4 cpu databasewarehouse.

i have been unable to reach my $60K budget for doubling my datawarehouse performance since last six months and I am loosing patience. I got quad IBM power 1.9 GHz, DDR1 memory to drop down from $120K to $100K. I only comfortable at a $70K pricepoint which is not going to happen.

The only compromise is Power 5 1.65 Ghz DDR-1 memory for around $60K. ( I rather have it at $50K pricepoint but I doubt it will happen.)

will decide a month from now.

I think Power 5 1.65 Ghz gives more bang for the buck than Itanium 2 1.5 Ghz esp for database applications which is more multi-threaded and memory latency sensitive.