Database performance matters
Whether you are running transactional or analytical workloads, database performance is a key driver to overall system performance. IBM DB2 is designed to deliver industry-leading performance. The results speak for themselves.
Leading benchmark records
Benchmarks are a great way to compare database performance across vendors. However, real world workloads can vary significantly in performance and high availability characteristics. DB2 is the clear leader in performance on production systems.
As of June 2013, DB2 holds the following leading benchmark records for database performance:
- DB2 achieves a new world record on the three-tier SAP® Sales and Distribution (SD) standard application benchmark with 266,000 SAP SD users [i]
- DB2 leads the SAP® Sales and Distribution (SD) two-tier standard application benchmark single server 32-socket result with 126,063 SAP SD users [ii]
- DB2 holds the first clustered database result published for the SAP® Transaction Banking standard application benchmark [iii]
- DB2 achieves the highest EjOPs per core number at 823 EjOPS per core on SPECjEnterprise2010 [iv]
- DB2 holds the #1 4-socket x86-64 TPC-C result in throughput for transactional performance [v]
Raw performance is critical to our clients and DB2 delivers the best performance numbers. However, the real value of our performance results lies in how they translate into lower operating costs for our clients. For instance, DB2 engineers strive to deliver the best per-core performance, this is important for clients in industries such as energy, mobile communications and financial services, who run database application workloads that use per-core pricing when determining total solution cost. Fewer cores for the same performance can translate into significant direct savings in licensing and ongoing annual software maintenance costs.
[i] Results of DB2® 10.5 on IBM Power 780 on the three-tier SAP SD standard application benchmark on SAP enhancement package 5 for SAP ERP 6.0, achieved 266,000 SAP SD benchmark users, certification # 2013010. Configuration: 8 processors / 64 cores / 256 threads, POWER7+ 3.72 GHz, 512 GB memory, running AIX 7.1. For more details, see http://www.sap.com/benchmark
[ii] Results of DB2® 9.7 on IBM Power System 795 on the two-tier SAP SD standard application benchmark on SAP enhancement package 4 for SAP ERP 6.0, achieved 126,063 SAP SD benchmark users, certification # 201046. Configuration: 32 processors/ 256 cores/ 1024 threads, POWER 7 4.0 GHz, 4096 GB memory, running AIX 7.1. For more details, see http://www.sap.com/benchmark
[iii] This benchmark fully complies with the SAP Benchmark Council regulations and has been audited and certified by SAP AG (certification number 2011035). Details can be obtained from http://www.sap.com/solutions/benchmark/trbk3_results.htm
[iv] WebSphere Application Server V8.5.5 and DB2 10.1 on IBM Power Linux 7R2, 16 cores. Result as of 2013/04/22: 13,161.07 SPECjEnterprise2010 EjOPS. Details can be obtained from http://www.spec.org/jEnterprise2010/results
[v] System x 3850 X5 can grow to 8 socket 80 cores, 4 socket 40 core configuration used for this result. Best tpmC results listed for non-IBM 4 socket systems as of 2011/07/26
DL585G7 Result: HP ProLiant DL585 G7: 1,193,472 tpmC at $0.69USD/tpmC, avail 2010/09/01, (4proc/48core/48thread)
DL580G7 Result: HP ProLiant DL580 G7: 1,807,347 tpmC at $0.49USD/tpmC, avail 2010/10/15, (4proc/32core/64thread)
x3850 X5 Result: IBM x3850 X5: 3,014,684 tpmC at $0.59USD/tpmC, avail 2011/09/22, (4proc/40core/80thread)
TPC-C is a trademark of the Transaction Performance Processing Council (TPC). The TPC web page is located at http://www.tpc.org
SAP and all other SAP product and service names mentioned herein are trademarks or registered trademarks of SAP AG in Germany and several other countries around the world. SAP benchmark information is located at http://www.sap.com/benchmark
SPECjEnterprise2010 is a trademark of the Standard Performance Evaluation Corporation (SPEC).
All benchmark claims are based on published information as of June 2013.
Performance Results and Information
Performance Best Practices