last updated: 2025-06-30
Introduction
There is huge knowledge available about SAP HANA Workload Classes, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, SAP Learning, other). The aim of this article is simplify and make content consumption easier with a centralized page. There is no reason to duplicate the already well prepared content, so the goal is to collect the available knowledge and put it in a well structured format. The logic of the page follows the earlier published articles in the same series.
🎓 The blog contains SAP Learning references. 📺
Table of Content (The internal links had been removed cause the new blogging platform only supports basic html, and the use of anchor links not supported.)
- Task 1. – Exercise
- Prerequisites
- Exercise 1.
- Exercise 2.
- Conclusion
- Task 2. – Documentation Library
- Where to find documentations in SAP Help Portal?
- Which are the master SAP Knowledge Base Articles?
- Where to find learning materials?
- Managing Workload Classes
- Hierarchies of Workload Classes
- Which other documentation is important regarding SAP HANA Workload Management?
- Which are the related SQL Statement collection reports?
- What blog posts can be helpful?
- Other articles in this series
- Other articles in connected series
- Useful bookmark
Task 1. – Exercise
Prerequisites
- Hypervisor (VMware Workstation Player / VMware Workstation Pro / or any alternatives)
- SAP HANA, express edition (3573213 – SAP HANA Express Edition – Central)
- SAP HANA Studio
Number of CPUs Available: 4.
Exercise 1.
The task is to create a workflow class and test its operation. The task is performed using the SAP HANA Studio tool and the SAP HANA Cockpit interface.
- In SAP HANA Studio I executed the commands with ‘SYSTEM’ user and setup the workload class for ‘DB_ADMIN’ user to manage the ‘HDBStudio’ related executions. The goal is to reject execution from this user while high CPU usage of the system.
- I checked the workload class with ‘SYSTEM’ user by using “HANA_Workload_WorkloadClasses_” report.
- I generated CPU load on the server (with executing different reports in same time).
- I executed SQL statement with ‘DB_ADMIN’ user. It failed.
- I checked the workload class, admission control events with ‘SYSTEM’ user by using “HANA_Workload_AdmissionControlEvents_” report (EVENT_REASON).
Commands:
CREATE WORKLOAD CLASS “WC_HXE_DBADMIN” SET ‘PRIORITY’ = ‘0’, ‘STATEMENT THREAD LIMIT’ = ‘3’, ‘STATEMENT MEMORY LIMIT’ = ‘4’;
ALTER WORKLOAD CLASS “WC_HXE_DBADMIN” SET ‘ADMISSION CONTROL REJECT CPU THRESHOLD’ = ’90’;
CREATE WORKLOAD MAPPING “WM_HXE_DBADMIN” WORKLOAD CLASS “WC_HXE_DBADMIN” SET ‘APPLICATION NAME’ = ‘HDBStudio’ , ‘USER NAME’ = ‘DB_ADMIN’;
Note: first the ‘ADMISSION CONTROL REJECT CPU THRESHOLD’ value was set to 50 then 90 for testing purposes.
Reference:
- 3259346 – How to create, modify and remove workload classes and workload mappings
Workload Class in SAP HANA Studio with “HANA_Workload_WorkloadClasses_” report:
Workload Class in SAP HANA Cockpit interface:
During the system had high CPU usage and I started to do execution in SAP HANA Studio tool with ‘DB_ADMIN’ user. The execution was rejected. It can be checked with “HANA_Workload_AdmissionControlEvents_” report (e.g. in SAP HANA Studio):
Reference:
- 3583014 – Rejected by workload class configuration with ‘Exceeded cpu threshold’ error
Exercise 2.
The task is to modify a workflow class and test its operation. The task is performed using the SAP HANA Studio tool and the SAP HANA Cockpit interface.
- Execute memory intensive report “HANA_Configuration_MiniChecks_” with DB_ADMIN user with previous workload class setup (Statement Memory Limit = 4). Execution successful.
- Modification on the workload class (Statement Memory Limit = 2).
- Execute memory intensive report “HANA_Configuration_MiniChecks_” with DB_ADMIN user with modified workload class setup. Execution failed.
Commands:
ALTER WORKLOAD CLASS “WC_HXE_DBADMIN” SET ‘PRIORITY’ = ‘0’, ‘STATEMENT THREAD LIMIT’ = ‘3’, ‘STATEMENT MEMORY LIMIT’ = ‘2’;
Workload Class in SAP HANA Cockpit interface:
The execution which was successful previously now failed.
Note: after resetting the parameter (to value 4), the execution will be successful again.
Conclusion
You can manage workload in SAP HANA by creating workload classes and workload class mappings. Workload classes can be configured in several ways depending on actual needs.
Task 2. – Documentation Library
IMPORTANT !
=================================================================
Where to find documentations in SAP Help Portal?
- SAP HANA Administration Guide for SAP HANA Platform – Workload Management
- SAP HANA Administration Guide for SAP HANA Platform – Managing Workload with Workload Classes
Which are the master SAP Knowledge Base Articles?
- 2222250 – FAQ: SAP HANA Workload Management
Where to find learning materials?
- SAP Learning – Setting up SAP HANA Workload Management > SAP HANA Workload Classes
=================================================================
Managing Workload Classes
The management of the workload class objects can be achieved with SQL statements/commands and with the SAP HANA Cockpit tool.
- SAP HANA Administration with SAP HANA Cockpit – Managing Workload Classes
- SAP HANA SQL Reference Guide for SAP HANA Platform – Workload Management Statements
Hierarchies of Workload Classes
- 3247119 – How to use Workload class Hierarchies
- 3544218 – Using Hierarchies of Workload Classes and their consequences in SAP HANA
- SAP HANA Administration Guide for SAP HANA Platform – Hierarchies of Workload Classes
Which other documentation is important regarding SAP HANA Workload Management?
- 3478705 – Workload class and mapping examples
- 2331857 – SAP HANA workload class support for SAP client applications
- 3271136 – How to balance CPU threads usage between applications and HANA system
- 3259346 – How to create, modify and remove workload classes and workload mappings
- 3583014 – Rejected by workload class configuration with ‘Exceeded cpu threshold’ error
- 3580898 – How to Verify Concurrency Limit, STATEMENT THREAD LIMIT Has Been Properly Applied for Workload Classes in SAP HANA
Which are the related SQL Statement collection reports?
The general way to do the monitoring is to use SQL commands. The relevant information can be reviewed with the following reports.
- 1969700 – SQL Statement Collection for SAP HANA
- “HANA_Workload_AdmissionControlEvents_” report
- “HANA_Workload_WorkloadClasses_” report
- “HANA_Workload_WorkloadClasses_Statistics_” report
What blog posts can be helpful?
- SAP Community – HANA Workload Management deep dive part I
- SAP Community – HANA Workload Management deep dive part II
- SAP Community – HANA Workload Management deep dive part III (Workload Classes)
Other articles in this series
✍️ Collected information about memory in context of SAP HANA
✍️ Collected information regarding partitioning in SAP HANA (with examples)
✍️ Collected information regarding High Availability and Disaster Recovery in SAP HANA
✍️ Collected information belongs to the topics of query execution and optimization in SAP HANA database
✍️ Collected information about reclaim / shrink / defragmentation topic in context of SAP HANA persiste…
Other articles in connected series
✍️ Where can I find knowledge and information belongs to SAP HANA?
✍️ Where can I find information about the available tools for SAP HANA (all types of use)?
Useful bookmark
🔖 2872774 – Bookmark of Frequently Asked Questions for SAP HANA
🔖 3311408 – Bookmark of SQL Statement Collection reports for SAP HANA
🔖 2658020 – List of SAP HANA SQL Error Codes
Do you have further questions?
Q&A link for SAP HANA: https://answers.sap.com/tags/73554900100700000996
Contribution
If you find any missing information belongs to the topic, please let me know. I am happy to add the new content. My intention is to maintain the content continuously to keep the info up-to-date.
Release Information
| Release Date | Description |
| 2025.06.30 | First/initial Release of the SAP Blog Post documentation (Technical Article). |
#SAPCHANNEL