page-brochureware.php

IBM Power Systems

Big Data and Analytics performance proof-points

Faster time-to-value for big data. Discover how Hadoop innovation can deliver faster, more affordable business insights.

Apache Spark SQL TPC-DS 3 TB four-stream throughput on IBM POWER9

For the systems and workload compared:

  • IBM® Power® System LC922 server delivers superior performance running multiple TPC-DS query streams with Apache Spark SQL
  • It delivers 1.30x the query results per hour running on IBM POWER9™ compared to Intel Xeon SP Gold 6140, which is 1.59x better in price and performance
Apache Spark SQL TPC-DS 3 TB four-stream throughput on IBM POWER9

System configuration

Power System Competitor
Hardware Four nodes of IBM Power LC922 (two 20-core/2.7 GHz/512 GB memory) using twelve 8 TB HDD, 10 GbE two-port, RHEL 7.5 LE for IBM POWER9 Four nodes of Intel Xeon Gold 6140 36 cores (2 x 18c chips) at 2.3 GHz; 512 GB memory, twelve 8 TB HDDs, 10 Gbps NIC, Red Hat Enterprise Linux 7.5
Software Apache Spark 2.3.0 located at http://spark.apache.org/downloads.html; and open source Hadoop 2.7.5 Apache Spark 2.3.0 located at http://spark.apache.org/downloads.html; and open source Hadoop 2.7.5

Notes:

  • Results are based IBM internal measurements running four concurrent streams of 99 distinct and diverse queries of varying complexity and length against a 3 TB data set. Results are valid as of 4/25/18 and tests were conducted under laboratory condition with speculative execution controls to mitigate user-to-kernel and user-to-user side-channel attacks on both systems. Individual results can vary based on workload size, use of storage subsystems, and other conditions.

IBM Db2 Warehouse running on IBM Power System L922 reduces software costs with superior core performance versus tested x86 systems

For the systems and workload compared:

  • The IBM® Power® System L922 costs less than the Intel 8168.
  • The Power L922 runs 2.54x more queries per hour per core than the Intel 8168.
  • The Power L922 cluster provides 2.44x better price performance than the Intel 8168 cluster.
  • The Power L922 solution enables 57% lower solution costs than using the Intel 8168.


IBM Power L922
(20-core, 512 GB)
Intel Xeon SP based 2-socket server
(48-core, 512 GB)
QpH 1
Total queries per hour
3064 QpH 2891 QpH
Server price 2 , 3 , 4
3-year warranty
$37,222 $52,330
Solution Cost 5
(three nodes)
Server + RHEL OS + Virtualization + Db2 @ $12,800* per core
$817,299
per node: ($13,341 + $12,077 + $256,000*)
$1,899,449
per node: ($30,126 + $3,919 + $614,400*)
QpH per $1000 3.74 QpH/$1000 1.53 QpH/$1000



System configuration

Power System Competitor
3x Power L922 servers with 20-cores and 512 GB RAM 3x Intel 8168 servers with 48-cores and 512 GB RAM

Notes:

  1. The results are based on IBM internal testing of IBM Db2® Warehouse running a sample analytic workload of 30 distinct queries of varying complexities (intermediate and complex). The results are valid as of 3/14/18 and are conducted under laboratory condition with speculative execution controls to mitigate user-to-kernel and user-to-user side-channel attacks on both systems. Individual results can vary based on workload size, use of storage subsystems, and other conditions.
  2. 3x IBM Power L922 (2x 10-core/2.9 GHz/512 GB memory) using two 300 GB SATA 7.2K rpm LFF HDD, 1x GbE two-port, 10 GbE two-port, 1x 16 Gbps FCA running DB2 Warehouse 2.5 and IBM Spectrum Scale™ 4.2 with RHEL 7.4.
  3. Competitive stack: 3x 2-socket Intel Xeon Scalable Processor (Skylake-SP) Platinum 8168 (2x 24-core/2.4 GHz/512 GB memory) using 2x 300 GB SATA 7.2K rpm LFF HDD, 1 Gb two-port, 10 GbE two-port, 1x 16 Gbps FCA, running Db2 Warehouse 2.5 and Spectrum Scale 4.2 with, RHEL 7.4
  4. Pricing is based on Power L922 http://www-03.ibm.com/systems/power/hardware/linux-lc.html and typical industry standard x86 pricing https://www.synnexcorp.com/us/govsolv/pricing/
  5. Db2 Warehouse pricing is based on USD regional perpetual license costs where certain discounts can apply.

Realize 1.8X application performance gains with Kinetica on IBM POWER9™ with NVLink 2.0 versus Kinetica on IBM POWER8™

For the systems and workload compared:

  • Improved application performance with Kinetica filtering Twitter Tweets
  • 80% more throughput on IBM Power System AC922 than IBM Power System S822LC for HPC

System configuration

IBM Power System AC922 IBM Power System S822LC for HPC
40 cores (2 x 20c chips) 20 cores (2 x 10c chips) / 160 threads
POWER9 with NVLink 2.0 POWER8 with NVLink
2.25 GHz, 1024 GB memory 2.86 GHz, 1024 GB memory
(4) Tesla V100 GPUs (4) Tesla P100 GPUs
(2) 6 Gb SSDs, 2-port 10 Gb Ethernet
Red Hat Enterprise Linux 7.4 for Power Little Endian (POWER9) running Kinetica 6.1 (Red Hat Enterprise Linux 7.4 for POWER8 running Kinetica 6.1

Notes:

  • Throughput results are based on running Kinetica “Filter by geographic area” queries on data set of 280 million simulated Tweets with 80 to 600 concurrent clients each with 0 think time.
  • Test date: November 27, 2017

IBM Corporation 2017®

IBM, the IBM logo, ibm.com, POWER and POWER8 are trademarks of the International Business Machines Corp., registered in many jurisdictions worldwide. Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates. Other product and service names may be the trademarks of IBM or other companies.

The content in this document (including any pricing references) is current as of July 22, 2015 and may be changed by IBM at any time. Not all offerings are available in every country in which IBM operates

THE INFORMATION CONTAINED ON THIS WEBSITE IS PROVIDED ON AN “AS IS” BASIS WITHOUT ANY WARRANTY EXPRESS OR IMPLIED INCLUDING WITHOUT ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE ANDY ANY WARRANTY OR CONDITION OF NON-INFRINGEMENT.

In no event will IBM be liable for damages arising directly or indirectly from any use of the information contained in this document.

All information contained on this website is subject to change without notice. The information contained in this website does not affect or change IBM product specifications or warranties. IBM’s products are warranted according to the terms and conditions of the agreements under which they are provided. Nothing in this website shall operate as an express or implied license or indemnity under the intellectual property rights of IBM or third parties.

All information contained on this website was obtained in specific environments, and is presented as an illustration. The results obtained in other operating environments may vary.

No licenses, expressed or implied, by estoppel or otherwise, to any intellectual property rights are granted by this website.