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/