SQL Server Performance Forum – Threads Archive

2 Itanium2â€™s v 4 Xeons?

I#%92m a BI developer and have a hardware question. We have recently specked up some new servers for our datawarehouse and OLAP solution, we have opted to go 64bit. A consultancy suggested 4 dual core processors per box (around 3GHz Xeons) with 16gig ram. On presenting the consultants report to our hardware manager he has now kitted out the servers with 2 (1.6MHz) dual core Itanium2#%92s. Also, the boxes only have 2 sockets so there#%92s no room to expand in the future. Without getting too caught up in what to do with the hardware manager what is the general consensus? Generally speaking should 2 (1.6MHz 64bit) dual core Itanium2#%92s outperform 4 (3Ghz 64bit) dual core Xeons? Any science or performance comparisons to demonstrate the case would be very much appreciated, mind you so would a yes or no.

see below as a starting point
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15002 at the single core level,
Itanium 2 is probably equal or slightly behind the Netburt Xeon,
the latest Opteron is better,
and the Core 2 line (Xeon 51xx and 53xx) are tops
(above based on SPEC CPU) Itanium shows strong advantage at high number of sockets,
definitely 16 and up.
Itanium has slightly better TPC-C at 4 socket dual core than Xeon 7140 (Netburst), which is a OLTP benchmark
there are no comparable TPC-H (DW) results
but I suspect that Itanium will be equal or below Xeon at 1-4 sockets In any case, at 2 sockets, the quad core Xeon X5355 is the strong winner, both in top performance and bang for the buck I am not a fan of buying a system with empty sockets, for room to grow.
buy what you need now,
buy a new system when you need to grow,
this is the best strategy for lowest total cost The argument should probably be
buy the 2 socket Xeon X5355 now for development/QA prototyping large load handling assessment
if it turns out you need about 2X more power,
buy the 4 socket quad core when it comes out in the next quarter,
if it turns out you need 4X or more power
buy a 16+ socket Itanium system

]]>