Re: POWER vs Intel for DB loads

From: Karl Arao <karlarao_at_gmail.com>
Date: Thu, 8 Aug 2013 10:30:03 -0500
Message-ID: <CACNsJnfJAk=hPMpR2qyzvFbd8JhRrXmJHxOnmnvnTGn9oMzOkQ_at_mail.gmail.com>

While you don't have the machine yet.. you can do all these comparisons using specint_rate2006, depends on what P750 you are getting then compare it to your intel hardware of choice. Here's the data points https://www.dropbox.com/s/ctlsrwmyrvh6t6e/spec.txt, the first column is the speed/core
You can see here http://goo.gl/xj7o8 how I used the specint_rate2006 for CPU comparison

• P550 Karl-MacBook:SPECint_rate2006 karl$ cat spec.txt | grep -i 550 | sort -nk1 | grep -i ibm | grep -v Intel | grep -v SLES | grep -v Red 22.375, 8, 4, 2, 2, 152, 179, IBM Corporation, IBM System p 550 (3.5 GHz 8 core), Feb-08 26.5, 8, 4, 2, 2, 179, 212, IBM Corporation, IBM System p 550 (4.2 GHz 8 core), Feb-08 32.875, 8, 4, 2, 2, 215, 263, IBM Corporation, IBM Power 550 (5.0 GHz 8 core), May-09
• P750 Karl-MacBook:SPECint_rate2006 karl$ cat spec.txt | grep -i 750 | sort -nk1 | grep -i ibm | grep -v Intel | grep -v SLES | grep -v Red 31.5625, 32, 4, 8, 4, 911, 1010, IBM Corporation, IBM Power 750 Express
  (3.3 GHz 32 core), Mar-10
  33.125, 32, 4, 8, 4, 949, 1060, IBM Corporation, IBM Power 750 Express
  (3.55 GHz 32 core), Mar-10
  35.9375, 32, 4, 8, 4, 1010, 1150, IBM Corporation, IBM Power 750 Express
  (3.61 GHz 32 core), Apr-11
  50, 32, 8, 4, 4, 1150, 1600, IBM Corporation, IBM Power 750 Express (3.5 GHz 32 core), Feb-13 54.375, 32, 8, 4, 4, 1230, 1740, IBM Corporation, IBM Power 750 Express
  (4.0 GHz 32 core), Feb-13
  
• E5 Karl-MacBook:SPECint_rate2006 karl$ cat spec.txt | grep -i intel | grep -i "E5-26" | sort -nk1 | grep -i sun | grep -v Blade 29.8125, 16, 2, 8, 2, 455, 477, Oracle Corporation, Sun Netra X4270 M3
  (Intel Xeon E5-2658 2.1GHz), Apr-12
  43.875, 16, 2, 8, 2, 628, 702, Oracle Corporation, Sun Fire X4170 M3 (Intel Xeon E5-2690 2.9GHz), Apr-12 43.875, 16, 2, 8, 2, 628, 702, Oracle Corporation, Sun Server X3-2 (Intel Xeon E5-2690 2.9GHz), Jul-12 44.0625, 16, 2, 8, 2, 630, 705, Oracle Corporation, Sun Fire X4270 M3
  (Intel Xeon E5-2690 2.9GHz), Apr-12
  44.0625, 16, 2, 8, 2, 630, 705, Oracle Corporation, Sun Server X3-2L (Intel Xeon E5-2690 2.9GHz), Jul-12

-- 
Karl Arao
Blog: karlarao.wordpress.com
Wiki: karlarao.tiddlyspot.com
Twitter: _at_karlarao <http://twitter.com/karlarao>


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 08 2013 - 17:30:03 CEST