Workload merging potential in SAP Hybris
Research output: Contribution to book/conference proceedings/anthology/report › Conference contribution › Contributed › peer-review
Contributors
Abstract
OLTP DBMSs in enterprise scenarios are often facing the challenge to deal with workload peaks resulting from events such as Cyber Monday or Black Friday. The traditional solution to prevent running out of resources and thus coping with such workload peaks is to use a significant over-provisioning of the underlying infrastructure. Another direction to cope with such peak scenarios is to apply resource sharing. In a recent work, we showed that merging read statements in OLTP scenarios offers the opportunity to maintain low latency for systems under heavy load without over-provisioning. In this paper, we analyze a real enterprise OLTP workload - - SAP Hybris - - with respect to statements types, complexity, and hot-spot statements to find potential candidates for workload sharing in OLTP. We additionally share work of the Hybris workload in our system OLTPShare and report on savings with respect to CPU consumption. Another interesting effect we show is that with OLTPShare, we can increase the SAP Hybris throughput by 20%.
Details
Original language | English |
---|---|
Title of host publication | DBTest '20: Proceedings of the workshop on Testing Database Systems |
Publisher | Association for Computing Machinery, Inc |
Number of pages | 6 |
ISBN (electronic) | 978-1-4503-8001-0 |
Publication status | Published - 19 Jun 2020 |
Peer-reviewed | Yes |
Publication series
Series | MOD: International Conference on Management of Data (DBTest) |
---|
Conference
Title | 2020 Workshop on Testing Database Systems, DBTest 2020 |
---|---|
Duration | 19 June 2020 |
City | Portland |
Country | United States of America |
External IDs
Scopus | 85086079960 |
---|---|
ORCID | /0000-0001-8107-2775/work/142253455 |