
last updated: 2024-05-05
Introduction
The article explains the SAP GUI – TCODE (Transaction Code): DBACOCKPIT (Load History) usage in details.
SAP GUI
Description
The load history is a collection of key performance indicators (KPIs) related to the SAP HANA hosts and indexserver processes. It allows to understand the SAP HANA activities over time and is one of the key information for SAP HANA performance analysis
Transaction Code:
DBACOCKPIT
DBA Cockpit menu structure (Navigation Panel):
Performance > Load History
Screen: Load History
Based on the actual problem there is option to choose the KPIs which needs to be investigated. This is a good technique to visualize the issue and as a first step to be familiar with the actual situation.
Inputs:
As a next step deeper investigation can be done by using the proper SQL Statement Collection report.
🔖 3311408 - Bookmark of SQL Statement Collection reports for SAP HANA
Examples:
Constantly high memory usage with an OOM (out-of-memory) event. Conclusion: memory issue, memory area needs to be investigated.
Normal memory usage with a sudden memory increase and an OOM (out-of-memory) event. Conclusion: memory usage in general was normal, however rapid rise happened. Probably invalid parameter setup.
Constantly high memory usage (while high CPU) with an OOM (out-of-memory) event and after the OOM both CPU and memory decreased. Conclusion: memory issue, memory area needs to be investigated, probably continuous load/unload happens.
CPU increase and decrease. Conclusion: the exact date and time can be identified which needs to be investigated.
Repeatedly quick CPU spike (on same time in every hour). Conclusion: exact repetition is observed.
Constantly high CPU pattern on work days (Monday-Friday). Conclusion: Probably invalid parameter setup.
Other examples
The following examples show a complete investigation process, where the first step was to examine the Load History graphical interface, which proved to be very useful.
Other articles in this series
🔖 3428763 - Bookmark of frequently used SAP GUI transaction codes for SAP HANA related investigations
Do you have further questions?
Please do not hesitate to contact me if you have question or observation regarding the article.
SAP Community for SAP GUI: https://community.sap.com/topics/gui
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 |
2024.05.05 | First/initial Release of the SAP Blog Post documentation (Product Information). |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
7 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |