IJBTT

SAP HANA Workload Management: A Comprehensive Study on Workload Classes
	© 2024 by IJCTT Journal
	Volume-72 Issue-11
	Year of Publication : 2024
	Authors : Puneet Aggarwal, Amit Aggarwal
	DOI :  10.14445/22312803/IJCTT-V72I11P105

How to Cite?

Puneet Aggarwal, Amit Aggarwal, "SAP HANA Workload Management: A Comprehensive Study on Workload Classes," International Journal of Computer Trends and Technology, vol. 72, no. 11, pp. 31-38, 2024. Crossref, https://doi.org/10.14445/22312803/IJCTT-V72I11P105

Abstract
This study investigates workload management challenges in SAP HANA’s in-memory columnar storage, specifically focusing on the complexities of handling mixed OLTP and OLAP workloads. Traditional database management approaches often fail to address SAP HANA’s unique architecture, which combines high-speed transaction processing with real-time analytics. Drawing on research into mixed workload optimization (May et al., 2015) and SAP HANA’s architectural evolution (Färber et al., 2017), this paper explores workload throttling, prioritization, and real-time monitoring strategies to optimize resource allocation. Our findings offer practical guidance for database administrators managing critical business applications with high data demands, such as finance and supply chain. Additionally, we examine tools and techniques for performance tracing in third party applications like Tableau (Tableau Software, 2023), providing an integrated perspective on maintaining optimal SAP HANA performance under peak load conditions.

Keywords
SAP HANA Workload Management, In-Memory Database, Mixed Workloads, OLTP and OLAP, Resource Allocation, Workload Throttling, Real-Time Monitoring, Database Performance Optimization, Admission Control, Workload Classes, Tableau Integration.

Reference

[1] What’s New in SAP HANA 2.0 SPS 07 in Administration and Monitoring, SAP Community Blog, 2023. [Online]. Available: https://community.sap.com/t5/technology-blogs-by-sap/what-s-new-in-sap-hana-2-0-sps-07-in-administration-and-monitoring/ba p/13554753
[2] Managing Workload with Workload Classes, SAP Help Portal, 2023. [Online]. Available: https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/5066181717df4110931271d1efd84cbc.h tml
[3] FAQ: SAP HANA Workload Management, SAP Note 2222250, 2023. [Online]. Available: https://userapps.support.sap.com/sap/support/knowledge/en/2222250
[4] FAQ: SAP HANA Memory, SAP Note 1999997, 2023. [Online]. Available: http://sapway.com/WILLSYS/HANA_Note/1999997 FAQ%20SAP%20HANA%20Memory.pdf
[5] FAQ: SAP HANA Threads and Thread Samples, SAP Note 2114710, 2023. [Online]. Available: https://userapps.support.sap.com/sap/support/knowledge/en/2114710
[6] HANA Workload Management Deep Dive – Part III, SAP Community Blog, 2023. [Online]. Available: https://community.sap.com/t5/technology-blogs-by-members/hana-workload-management-deep-dive-part-iii/ba-p/13568799#mapping
[7] Managing Workload with Workload Classes in SAP HANA, SAP HANA Administration Guide, 2023. [Online]. Available: https://help.sap.com/doc/eb75509ab0fd1014a2c6ba9b6d252832/2.0.03/en-US/SAP_HANA_Administration_Guide_en.pdf
[8] Memory Management and CPU Thread Allocation, SAP HANA Administration Guide, 2023. Retrieved from https://help.sap.com/doc/eb75509ab0fd1014a2c6ba9b6d252832/2.0.07/en-US/SAP_HANA_Administration_Guide_en.pdf