Skip to Content
BW (SAP Business Warehouse)

BW on HANA benchmarks

Tags:

Are there any formal benchmarks defined to analyse the performance of BW on HANA?

Yes, SAP has released a formal benchmark test called BW EML (Enhanced Mix Load) benchmark which considers:

  • Near real-time reporting
  • Ad-hoc reporting capabilities
  • Reduction of TCO.

Please see these links for more detailes and results:

http://www.sap.com/campaigns/benchmark/appbm_bweml.epx

http://www.sap.com/solutions/benchmark/bweml-results.htm

The following link will provide more inside into Lenovo's new record and how the BW EML benchmark works.

https://blogs.saphana.com/2015/03/19/behind-sap-bw-eml-benchmark/

I heard about a HANA Petabyte test. Where can I found more information?

The SAP HANA One Petabyte Test with a datamodel similiar to what many SAP BW customers are using:

https://blogs.saphana.com/2012/11/12/the-sap-hana-one-petabyte-test/

For SAP HANA performance benchmarks, please see:

Whitepaper - SAP HANA Performance

http://scn.sap.com/docs/DOC-60352

Whitepaper - SAP and HP Breaking Analytic Performance Barriers with SAP HANA and HP AppSystems

https://scn.sap.com/docs/DOC-61050

Performance Test Report - SAP HANA

http://scn.sap.com/docs/DOC-60349

Did SAP or a partner publish benchmarks with regards to lower TCO for BW on HANA?

Yes, there is a report from Joshua Greenbaum, and a benchmark report from HP. Please see the links for more detail.

SAP has also conducted individual benchmarks with SAP customers who migrated their BW systems on RDBMS to BW on HANA. Please contact your account team for results from SAP reference customers.

https://scn.sap.com/docs/DOC-61050

http://scn.sap.com/docs/DOC-60349

Is there any benchmark or performance comparison of BW on HANA versus BW on a traditional DB?

There is a great performance test benchmarks published by Dr. Berg.

http://sapinsider.wispubs.com/Assets/Blogs/2013/September/Real-HANA-Performance-Test-Benchmarks

In addition read this blog here comparing the performance of a 60TB BW system before and after migration from Oracle to HANA.

http://scn.sap.com/people/sheetal.jain/blog/2015/05/21/hana-performance-test-benchmarks

Are there any studies about HANA's TCO and ROI?

IDC conducted a very interesting ROI study with the University of Kentucky.

https://blogs.saphana.com/2014/04/08/have-you-measured-your-sap-hana-roi/