page-brochureware.php

IBM Power Systems

Database, OLTP, and ERP performance proof-points

IBM Power Systems delivers industry-leading performance for database, online transaction processing (OLTP) and enterprise resource planning (ERP) workloads.

Reduce database as a service (DBaaS) operating costs with IBM® Power® System L922 running EnterpriseDB Postgres Advance Server 10

For the systems and workload compared:

  • Power L922 enables 2.4X price-performance leadership over tested Intel Xeon SP Gold 6148 servers
  • Power L922 provides 40% better system-level performance at a 40% lower system cost
  • Power L922 offers a superior cost efficiency for your EnterpriseDB workloads
Virtualized EnterpriseDB on IBM POWER9 performance leadership

System configuration

IBM Power System L922 Intel Xeon Skylake Gold 6148
IBM Power L922 (2x 10-core/2.9 GHz/256 GB memory) Two-socket Intel Xeon Skylake Gold 6148 (2x 20-core/2.4 GHz/256 GB memory)
2x 300 GB SATA 7.2K rpm LFF HDD, 2x 300 GB HDD
10 Gb two-port 1 Gb two-port
1x 16 Gbps FCA 1x 16 Gbps FCA
EDB Postgres Advanced Server 10 EDB Postgres Advanced Server 10
RHEL 7.5 with IBM PowerVM® (four partitions with five cores each) RHEL 7.5 KVM (four VMs with 10 cores each)



Notes:

  • This claim is based on IBM internal testing of multiple VM images running pgbench benchmark at a scale factor of 300, 20 GB buffer size. Results are valid as of 4/19/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 result can vary based on workload size, use of storage subsystems, and other conditions.
  • Pricing is based on IBM Power L922 pricing, EDB: https://webcms.enterprisedb.com/products/subscriptions, and publicly available x86 pricing.

Virtualized EnterpriseDB Postgres Advanced Server 9.5

For the systems and workload compared:

  • IBM Power® System S822LC for Big Data delivers 2.12x price performance leadership over Intel Xeon E5-2699 v4.
Virtualized EnterpriseDB Postgres Advanced Server 9.5

System configuration

Power S822LC for Big Data Xeon E5-2699 v4
20-c Power S822LC for Big Data 44-c HP DL380
2.9 GHz IBM POWER8®, 160 threads 2.2 GHz Intel Xeon® E5-2699 v4, 88 threads
256 GB memory, 22 VMs 256 GB memory, 22 VMs
(1) 2-port 10 GB Ethernet (1) 2-port 10 GB Ethernet
(1) 2-port 16 Gbps FCA (1) 2-port 16 Gbps FCA
(2) 1 TB SATA LFF HDD (2) 300 GB SATA LFF HDD
EDB Postgres Advanced Server® 9.5 EDB Postgres Advanced Server® 9.5
RHEL 7.2 Guests with KVM RHEL 7.2 Guests with KVM

Notes:

MongoDB YCSB POWER8 leadership

For the systems and workload compared:

  • IBM Power® System S822LC for Big Data delivers 1.68x price performance leadership over Intel Xeon E5-2690 v4 running on cloud workload.
MongoDB YCSB POWER8 leadership

System configuration

Power S822LC for Big Data Xeon E5-2690 v4
20-c Power S822LC for Big Data 28-c HP DL380
2.9 GHz IBM POWER8®, 160 threads 2.6 GHz Intel Xeon® E5-2690 v4, 56 threads
128 GB memory 128 GB memory
(1) 2-port 10 GB Ethernet (1) 2-port 10 GB Ethernet
(1) 2-port 16 Gbps FCA (1) 2-port 16 Gbps FCA
(2) 1 TB SATA LFF HDD (2) 300 GB SATA LFF HDD
MongoDB 3.3.8 MongoDB 3.3.8
RHEL 7.2 RHEL 7.2

Notes:

  • Based on IBM internal testing of single system and OS image running Yahoo Cloud Services Benchmark (YCSB) 0.6.0, 1M record workload at 50/50 read/write factor. Results valid as of 8/24/16. Power8 total system throughput produced 288,824 ops and Xeon E5-2690 produced 205,951 ops. Tests conducted under laboratory condition; individual results can vary based on workload size, use of storage subsystems & other conditions.
  • Configurations represent the processor running in favor performance mode and the MongoDB server on 1 socket & the YCSB application workload on the 2nd socket. IBM Flash 900 storage was used on both servers for testing.
  • Pricing is based on:

EnterpriseDB Postgres Advanced Server 9.5 POWER8 performance

For the systems and workload compared:

  • IBM Power® System S822LC for Big Data delivers 1.62x price performance leadership over Intel Xeon E5-2690 v4.
EnterpriseDB Postgres Advanced Server 9.5 POWER8 performance

System configuration

Power S822LC for Big Data Xeon E5-2690 v4
16-c Power S822LC for Big Data 28-c HP DL380
3.3 GHz IBM POWER8®, 160 threads 2.6 GHz Intel Xeon® E5-2690 v4, 56 threads
256 GB memory 256 GB memory
(1) 2-port 10 GB Ethernet (1) 2-port 10 GB Ethernet
(1) 2-port 16 Gbps FCA (1) 2-port 16 Gbps FCA
(2) 1 TB SATA LFF HDD (2) 300 GB SATA LFF HDD
EDB Postgres Advanced Server® 9.5 EDB Postgres Advanced Server® 9.5
RHEL 7.2 RHEL 7.2

Notes:

ScyllaDB on IBM Power System LC922

IBM® Power® System LC922 running cassandra-stress delivers superior performance with ScyllaDB compared to Cassandra on tested x86 systems at a lower price

For the systems and workload compared:

  • Power LC922 provides 3.9x better price-performance compared to Intel® Xeon® SP Gold 6140 based servers
  • Power LC922 provides 216% more performance per system
  • Power LC922 enables 22% lower server cost


IBM Power LC922
(44-core, 256 GB)
Intel Xeon SP based
two-socket server
(36-core, 256 GB)
Operations per second 1
Performance
906,463 286,627
Operations per second per $
Price performance
35 9
Server price 2, 3, 4
Includes 3-year warranty
$25,615 $31,373

System configuration

Power LC922 Intel Xeon SP Gold 6140
IBM POWER9™, 2x 22-core/2.6 GHz/256 GB memory Two-socket Intel Xeon SP Gold 6140, 2x 18-core/2.3 GHz/256 GB memory
Two internal HDD Two internal HDD
40GbE 40GbE
1.6 TB NVMe adapter running Scylla Enterprise 2018.1.0 1.6 TB NVMe adapter running open source Cassandra 3.11.2
RHEL 7.5 LE for POWER9 RHEL 7.5



Notes:

  1. The results are based on IBM internal testing of cassandra-stress workload using Gaussian 9M, 4.5M, 10K model with 80% read/20% write operations. Results are valid as of 05/21/18 and the tests were conducted under laboratory conditions 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. IBM Power System LC922 (2x 22-core/2.6 GHz/256 GB memory) using two internal HDD, 40GbE, one 1.6 TB NVMe adapter running Scylla Enterprise 2018.1.0 on RHEL 7.5 LE for POWER9
  3. Competitive stack: Two-socket Intel Xeon SP (Skylake) Gold 6140 (2x 18-core/2.3 GHz/256 GB memory) using two internal HDD, 40GbE, one 1.6 TB NVMe adapter running open source Cassandra 3.11.2 on RHEL 7.5
  4. Pricing is based on Power LC922 (refer http://www-03.ibm.com/systems/power/hardware/linux-lc.html) and publicly available x86 pricing.

Virtualized MariaDB 10.1 Sysbench 1.0 performance

For the systems and workload compared:

  • IBM Power® System S822LC for Big Data delivers 1.84x price performance leadership per virtual machine over Intel Xeon E5-2690 v4 running on sysbench workload.
  • Power S822LC for Big Data delivers 1.74x price performance leadership per transaction over Intel Xeon E5-2690 v4 running on sysbench workload.
  • Power S822LC for Big Data delivers 42% more virtual machines per server than a Xeon 28-core E5-2690 v4 system running the sysbench workload.
  • Power S822LC for Big Data delivers 35% more transactions per second per server than a Xeon 28-core E5-2690 v4 system running the sysbench workload.
Virtualized MariaDB 10.1 Sysbench 1.0 performance

System configuration

Power S822LC for Big Data Xeon E5-2690 v4
20-c Power S822LC for Big Data 28-c HP DL380
2.9 GHz IBM POWER8®, 160 threads 2.2 GHz Intel Xeon® E5-2690 v4, 56 threads
384 GB memory, 20 VMs 256 GB memory, 14 VMs
(1) 2-port 10 GB Ethernet (1) 2-port 10 GB Ethernet
(1) 2-port 16 Gbps FCA (1) 2-port 16 Gbps FCA
(2) 1 TB SATA LFF HDD (2) 300 GB SATA LFF HDD
MariaDB 10.1.16 MariaDB 10.1.16
Ubuntu 16.04 Guests with KVM Ubuntu 16.04 Guests with KVM

Notes:

  • Results are based on IBM internal testing of single system running multiple virtual machines with Sysbench read-only workload and are current as of August 22, 2016. Performance figures are based on running 24 M record scale factor per VM. Power8 total system throughput produced 15,903 tps and Xeon E5-2690 produced 11,727 tps. Individual results will vary depending on individual workloads, configurations and conditions.
  • Power S822LC for Big Data; 20 cores / 160 threads, POWER8; 2.9 GHz , 384GB memory MariaDB 10.1.16, 20 8vcpu VMs of Ubuntu 16.04 with KVM compared to competitive stack: HP Proliant DL380 28 cores / 56 threads; Intel E5-2690 v4, 2.6 GHz; 256 GB memory, MariaDB 10.1.16, 14 4vcpu VMs of Ubuntu 16.04. with KVM
  • Each system was configured to run at similar per VM throughput levels and the number of VMs were increased for each system until total system throughput showed maximum throughput levels.
  • Pricing is based on:

SAP BW Enhanced Mixed Load (BW-EML) with SAP Netweaver 7.31 and SAP HANA 1.0

For the systems and workload compared:

  • IBM Power System E870 obtained 192.750 adhoc navigation steps per hour versus 191.170 navigation steps per hour for Dell PowerEdge R930.
  • Power E870 achieved 1.81X more steps per hour/per core.
SAP BW-EML graph comparing POWER8 to Xeon E7-8890 V3, Xeon E7-4890 V2, and Xeon E7-4880 V2 navigation steps per hour per core

System configuration

Power E870 Dell PowerEdge R930
4.19 GHz, POWER8, 4 processors, 40 core, 320 threads, 1024 GB, OS: SUSE Linux Enterprise Server (SLES) 11, SAP Netweaver 7.31, SAP HANA 1.0 2.5 GHz, Intel Xeon E-7 8890 V3, 4 processors, 72 core, 144 threads, 1024 GB, SUSE Linux Enterprise Server (SLES) 11, SAP Netweaver 7.40, SAP HANA 1.0

Notes:

  • IBM Power System E870 on the SAP BW-EML standard application benchmark running SAP Netweaver 7.31 application, 4 processors / 40 cores / 320 threads, POWER8, 4.19GHz, 1024 GB memory, 192.750 adhoc navigation steps per hours on SUSE Linux Enterprise Server 11 and SAP HANA 1.0, Certification #: 2015024. Result valid as of June 1, 2015. Source: http://www.sap.com/benchmark.
  • Dell PowerEdge R930 on the SAP BW-EML standard application benchmark running SAP Netweaver 7.40 application, 4 processors / 72 cores / 144 threads, Intel Xeon E-7 8890 V3, 2.5 GHz, 1024 GB memory, 172.450 adhoc navigation steps per hours on SUSE Linux Enterprise Server 11 and SAP HANA 1.0, Certification #: 2015039. Result valid as of September 28, 2015. Source: http://www.sap.com/benchmark.
  • Dell PowerEdge R920 on the SAP BW-EML standard application benchmark running SAP Netweaver 7.31 application, 4 processors / 60 cores / 120 threads, Intel Xeon E-7 4890 V2, 2.8 GHz, 1024 GB memory, 137.010 adhoc navigation steps per hours on SUSE Linux Enterprise Server 11 and SAP HANA 1.0, Certification #: 2014044. Result valid as of November 20, 2014. Source: http://www.sap.com/benchmark.
  • HP DL580 Gen8 on the SAP BW-EML standard application benchmark running SAP Netweaver 7.30 application, 4 processors / 60 cores / 120 threads, Intel Xeon E-7 4880 V2, 2.5 GHz, 1024 GB memory, 126980 adhoc navigation steps per hours on SUSE Linux Enterprise Server 11 and SAP HANA 1.0, Certification #: 2014009. Result valid as of March 26, 2014. Source: http://www.sap.com/benchmark.

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.