
last updated: 2025-01-14
Introduction
During the process of operating and monitoring the SAP HANA database you probably need huge knowledge and information. The knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I have created a centralized page. Further I would like to help you to find the best available way to get the knowledge (information) in time. It is essential to identify that your needs or question belongs to for example a "How-to" question or a known product issue, so the required information probably already available, you need only find them. In that case the information is available right now. If you need further assistance (in case of more complex issue / question) so probably you need help from SAP Support which is more time consuming. Understanding and keeping the rules, requirements of the support process will ensure the effective support in a timely manner. The analyzation of the issue can be done by you based on available documentations like traces and logs and also analyzation tools and techniques.
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.)
Where can I find knowledge and information belongs to SAP HANA?
SAP Help Portal
This is the initial entry point of the official SAP HANA documentations.
SAP Help Portal - Home
On-Premise:
☁ Cloud:
❗Remark: The above list is not a complete list of the available pages only an extract from the most important ones. The menu structure needs to be discovered by each user based on the actual requirement.
SAP Support Portal
This is the initial entry point of the official SAP Notes, Knowledge Base Articles, Guided Answers and more. There is information about the ways to reach out SAP HANA Product Support (PS) or links to SAP Software Download Center.
SAP Support Portal - Home
On-Premise:
☁ Cloud:
❗Remark: The above list is not a complete list of the available pages only an extract from the most important ones. The menu structure needs to be discovered by each user based on the actual requirement.
SAP Learning
Grow your skills. Future-proof your career. Learn SAP for free, anywhere, anytime.
❗Remark: The above list is not a complete list of the available pages only an extract.
open SAP
❗Update: The openSAP platform will be discontinued in July 2024. Check out the dedicated FAQ page.
open SAP delivers innovative learning for everyone with expert-led content, made for you by SAP.
❗Update: New home for openSAP courses
open SAP MicroLearning
Learning site with multiple SAP related learning content.
SAP Community
❗Update: A New Home in the New Year for the SAP Community
In many case the community can give the proper answer to the question within no time. Also many information already available. It can be a good choice from time perspective.
❗Remark: The above list is not a complete list of the available pages only an extract. The menu structure needs to be discovered by each user based on the actual requirement.
SAP Guided Answers
Interactive documentation designed to help troubleshoot issues, navigate processes and guide through tasks.
❗Remark: The above list is not a complete list of the available pages only an extract. The menu structure needs to be discovered by each user based on the actual requirement.
SAP Help Portal - Support Content (prev. SAP Support/Community Wiki)
❗Update: PS WIKI content had been migrated to SAP Help Portal.
Repository maintained by engineers with technical content displaying configuration scenarios, system behaviour, recommendations, product FAQ and much more.
❗Remark: The above list is not a complete list of the available pages only an extract. The menu structure needs to be discovered by each user based on the actual requirement.
SAP HANA Academy
❗Update: The SAP HANA Academy’s YouTube Channel has been closed.
The SAP HANA Academy provides Technical Enablement, Implementation and Adoption Support for Customers and Partners with 1000’s of free tutorial videos.
SAP Press (Rheinwerk)
Rheinwerk Publishing write books and e-books that educate the IT and business community.
SAP Notes & Knowledge Base Articles
Here are the list of the most important SAP Notes & Knowledge Base Articles which belongs to SAP HANA. The list contains elements which explains support processes, different types of communications or solution finding. There are some initial and essential documentation also listed below.
IMPORTANT !
=================================================================
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
Entry point to the knowledge of SAP HANA
There is a basic SAP Notes & Knowledge Base Article (belongs to SAP HANA) which represents general information and acts like an essential entry point to the knowledge.
=================================================================
Central Notes
There are some central documentation belongs to SAP HANA. These are essential documentations.
☁ Cloud:
On Premise:
SAP HANA Studio
SAP HANA 2.0 Cockpit
Operating Systems
Application Component Hierarchy
The following SAP Note is essential to understand the component structure of SAP HANA in case of the incident handling. To open a case in a proper component, will save a lot of time, because there is no need to reroute/redirect the case to the component where the issue belongs to.
Already known issues
The already known issues are documented well and solution or workaround can be implemented using the SAP recommendations.
Information needed by Product/Development Support
The following information will be necessary to open a support ticket in a proper way in SAP HANA component.
Special Support Processes
In some scenario there are special process handling in place.
♻️ Business One powered by SAP HANA
♻️ SAP HANA Service / SAP HANA Cloud
In general the following information needs to be collected from cloud services to be able to identify the exact service. This is important to route the case to the proper component.
Background
Process
❓ Support / Consulting / How-To
There are different types of "support" processes need to be used in different scenarios.
⤵️ Support
Definition: SAP Product Support (PS) and Development Support (DS) working on reported issues and do support to customers with their incidents.
⤵️ Consulting
❗Remark: Incidents classified as How-To or Consulting requests should not be raised via a Support incident.
⤵️ How-to Questions and Community
The next SAP Knowledge Base Articles explains the usage of the community channel in case of "how-to" questions.
📄 Logs, Dumps and Traces
There are different files necessary in different types of investigation. The SAP Knowledge Base Article lists all the available trace types and the reference documentations.
The below sub-sections gives more information about the usage of the different types of traces, including how to gather them and when to collect them (in case of what kind of issue we need them).
📄 Full System Info Dump (FSID)
SAP HANA full system info dump (FSID) is a collection of trace files and configuration that is collected upon request from SAP Support to analyze an issue at SAP HANA Database level. This is an essential information for the investigation the issue or root cause analysis.
⚠️ IT DOES NOT NEED TO BE COLLECTED IN REAL TIME ⚠️
On Premise:
☁ Cloud:
❗Remark: When you open a case e.g. for an RCA (root cause analysis) that is a good practice to upload the full system info dump for analysis (SYSTEMDB and Tenant DB) right away.
❓Question: Why SAP need all of these files (SYSTEMDB and Tenant DB)?
📄 Runtime Dump (RTE)
A SAP HANA runtime dump is a text file that provides various information about the current state of the SAP HANA database. Runtime dumps are essential for SAP support to understand the SAP HANA behavior in a problem situation (real time).
⚠️ IT NEEDS TO BE COLLECTED IN REAL TIME ⚠️
On Premise:
☁ Cloud:
❗Remark: When you experience the issue, collect the runtime dump during the issue occurs (e.g. high CPU, hung system, slow system, general performance issue) in real time.
📄 Kernel Profiler
The SAP HANA kernel profiler is an expert tool that samples call stack of threads on a regular basis. This information can be helpful to identify low-level bottlenecks in the SAP HANA database.
📃 Server snapshot (SAP Kernel snapshot)
Server snapshot (also known as SAP Kernel snapshot) is a feature available since SAP NetWeaver ABAP Kernel 740. It is a concept of the NetWeaver ABAP application server which aims to save the most important system information automatically when system is in an abnormal situations.
SAP Help Portal:
📄 Gstack information
Gstack information has to be created on OS level during a high CPU/Memory consumption when the runtime dump creation is failing.
📃 OS Kernel Stack Backtraces
If there is a high system CPU utilization and a low user CPU utilization not the application itself is utilizing the CPU but an operation in the OS kernel.
📄 Linux var log messages (/var/log/messages)
Operating system (OS) log data. In many case the folder /var/log/messages contains also important information which help to investigate the exact issue.
📄 Linux sapsysinfo
Provides a simple option for collecting Linux-relevant system information.
🔍 Analyzing Tools (Features, Extensions) and Techniques
The following sections list the available tools and techniques which can be used during the analyzation of the issue. The section focus on different techniques and the usage of the tools.
Further information about the tools itself (installation, configuration) can be found in the other articles:
✍️ Where can I find information about the available tools for SAP HANA (all types of use)?
📄 SAP HANA SQL Statement Collection
The reports are executable SQL statements which gives further information about the system or issue during the analysis of complex problems.
SAP Help Portal:
SAP Knowledge Base Article:
📄 SAP HANA KPI Collector (hdbkpic)
SAP HANA KPI Collector (hdbkpic) is a command line tool to collect SAP HANA database KPI information during troubleshooting.
SAP Knowledge Base Article:
🔧 SAP HANA Dump Analyzer
The SAP HANA dump analyzer can be used to show certain important pieces of information in a different way to simplify the analysis.
SAP Knowledge Base Article:
SAP Community:
🔧 SAP Kernel Snapshot Analyzer
The kernel snapshot analyzer is a standalone tool to systematically analyze issues from snapshot files or dev traces and create analysis reports. It highly simplifies the root cause analysis for SAP NetWeaver ABAP relevant issues and makes the troubleshooting experience easier and more user-friendly.
SAP Knowledge Base Article:
SAP Community:
🧩 Explain Plan - SAP HANA studio
The Explain Plan is a quick lightweight tool that shows you a compiled plan in tabular form without executing it. Explain Plan is a feature of the SAP HANA studio.
SAP Help Portal:
SAP Notes / Knowledge Base Articles:
🧩 Plan Visualizer (PlanViz) - SAP HANA studio
To help you understand and analyze the execution plan of an SQL statement, you can generate a graphical view of the plan. Plan Visualizer is a feature of the SAP HANA studio.
SAP Help Portal:
SAP Knowledge Base Articles:
SAP Support Wiki:
SAP Community:
🧩 Plan Trace - SAP HANA studio
Plan trace enables you to collect SQL queries and their execution plans, executed in a given time frame for a particular application session. Plan Trace is a feature of the SAP HANA studio.
SAP Help Portal:
SAP Knowledge Base Articles:
🔍 Analyzing Techniques
There are some available documentations about how to start investigations on your own in case of experiencing issues.
SAP Help Portal:
SAP Knowledge Base Articles:
Using the contents of the SAP Knowledge Base article can prevent possible future problems from occurring.
What needs to be collected?
📉 Performance (PERF.)
Structured analysis of a performance-related problem.
🔋 Out of Memory (OOM)
🚫 Blocked Savepoint
SAP Knowledge Base Article:
SAP Community:
🔋 Disk Utilization
🌐 Product Support - Main Channel - Case/Incident
The following section explains the process itself (create, change, close) and the possible options which can happen with the case/incident (e.g. priority change such as increase or decrease and the possible reasons of the change, or duplicated incident which is not allowed by SAP Policy, etc).
⚠️ Terminology
Terminology - case vs. incident
⏏️ Create/Open/Reopen case/incident
Best practices to create the case/incident.
🔄 Change support case details
What and how can we change?
📎 Attachment
Information belongs to attachment (including file size).
🛃 Support Assistant
⚠️ Priority
Policy regarding the priority of the case.
❗Remark: There are restrictions which categorise the case into "Very high" priority. If these are not valid the incident will be decreased to a lower priority by SAP.
⚠️ 1 Problem in 1 Case
1 Problem in 1 Case rule/policy.
It is mandatory to have separate cases for different (subsequent) problems as per SAP policy (to provide clear and consistent resolution for each problem on each system). SAP cannot handle multiple/subsequent issues in one case. This is against SAP policy. The System ID identifies the actual system where the issue belongs.
⚠️ System ID
Correct System ID usage policy.
SAP Community:
❗Remark: If you experience an issue on multiple environment (e.g. test/dev/prod) you need to open 3 different case each one on the proper System ID (SID). This is not a duplication. SAP cannot handle the different systems in a same case, even if the issue seems to be the same. Also different system could have different version/revision or setup configuration. When FSID (full system info dump) files uploaded it has to match the reported System ID (SID), so there is no confusion. As a best practice the case number can be referred to indicate there is a connection between the cases.
⚠️ Duplicate case/incident
Duplicate incident policy.
❗Important: You are not allowed to open multiple incident for the same issue. This is against SAP policy. If this happens the duplicated incident has to be closed immediately. Usually the earlier case (which was opened previously) has already processed and/or assigned to processor, so the previous one needs to be keep alive.
⚠️ 24 hours support
24 hours support policy.
❗Remark: In general the 7x24 support is available in English. There are few exceptions.
🔺 Escalation
How the escalation works?
❗Remark: Escalation, priority change, speed up request can be done by you or based on your request. Do NOT open new case when you have already a case opened. In this situation ask through the proper channel to increase the priority of the case because of the changed situation.
🎦 Screen Sharing
It is not always feasible to look into the issue in real time. Each step takes a long time, can require documentation access, and is not efficient to do so in a meeting, especially for performance cases.
🆗 Close case/incident
How to close the case/incident properly?
📅 Automatic Closure Time/Automatic Confirmation Time
Information regarding the Case Automatic Confirmation Time (Automatic Closure Time).
🔄 Feedback
🌐 Product Support - Other Channels
Next to case/incident there are other Product Support channels available.
The next SAP Knowledge Base Articles explains the usage of the different channels.
💼 Schedule a Manager (SaM)
Schedule a Manager is a Real-Time Support channel that allows you to book a phone call with product support manager to discuss a high-priority incident.
🔧 Schedule an Expert (SaE)
Schedule an Expert for open incidents enables you to book a 30-minute call to discuss technical details of the incident with the assigned support engineer.
SAP Community Blog Post:
🔧 Ask an Expert Peer
Ask an Expert Peer allows customers to submit support-related questions to an expert peer group via a chat widget. When you submit a question to Ask an Expert Peer, a qualified and approved external expert works with you in a private conversation to resolve your issue through chat in real-time.
💻 Expert Chat (Chat Support)
Information regarding Expert Chat support service:
SAP Knowledge Base Articles:
SAP Community Blog Post:
📈 Technical Performance Optimization (TPO)
Technical performance optimization can yield improvements in a customer’s SAP solution by helping the customer configure the solution in an optimal way. The identification and elimination of costly performance bottlenecks optimize the response times and throughput of the SAP solution.
🌐 Product Support - Automated Channels
There are automated tools that help customers perform analysis as self-support.
More complex tools in section: 🔍 Analyzing Techniques
💻 Support Log Assistant
The Support Log Assistant is a new service/tool that allows users to automatically analyze their support-related files directly from within their browser.
SAP Knowledge Base Articles:
🌐 Remote Support
Set up remote access so that SAP Support can quickly diagnose and solve cases you report.
SAP Support Portal:
SAP Notes:
🔓 R/3 Support
Open R/3 connection and provide login credentials for the system in the Customer Remote Logon Depot as per following notes.
Set the following authorizations for the sap product support user: S_DBCON and S_RZL_ADM. They are needed to monitor the database and collect the required data to move on with the analysis.
Provide access at least to following transactions DB01, DB02, DB13, DB20, DB21, ST03, ST04, ST05, ST06, ST11, ST12, ST22, SM21, SM36, SM37, SE38, SM50, SM51, SM66 and AL11.
🔓 SAP HANA database / SAP HANA MDC
Open a HANA Studio connection as described in SAP Notes.
Knowledge Sources
The next SAP Knowledge Base Articles contains the links of the available sources.
Customer Influence and Adopt site
An Enhancement Request (ER) is a request for future product enhancements. You have the ability to work more directly with SAP technology and development group.
Other articles in this series
✍️ Where can I find information about the available tools for SAP HANA (all types of use)?
Other articles in connected 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 about reclaim / shrink / defragmentation topic in context of SAP HANA persiste...
Do you have further questions?
Please do not hesitate to contact me if you have question or observation regarding the article.
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 |
2023.03.29 | First/initial Release of the SAP Blog Post documentation (Product Information). |
2023.05.12 | Create sub-section Logs, Dumps and Traces and add section Linux var log messages (/var/log/messages) |
2023.05.13 | Create sub-section Support / Consulting / How-To and re-structured the content |
2023.05.20 | Create sub-section Analyzing Tools and Techniques |
2023.07.13 | Section restructured: Managing case/incident |
2023.08.06 | Section updated: Managing case/incident Sub-section added: SAP HANA SQL Statement Collection |
2023.08.07 | Section renamed: from Managing case/incident to Product Support - Main Channel - Case/Incident Section renamed: from Product Support Channels to Product Support - Other Channels |
2023.08.25 | Create sub-section Automatic Closure Time/Automatic Confirmation Time |
2023.09.04 | Create sub-section Feedback |
2023.09.14 | Create sub-section Special Support Processes |
2023.09.15 | Create sub-section Remote Support |
2023.09.24 | Create section SAP Learning and openSAP |
2023.10.09 | Create section Product Support - Automated Channels |
2023.11.23 | Create sub-section Screen Sharing |
2023.12.06 | Create sub-section Technical Performance Optimization (TPO) |
2023.12.13 | Create sub-section Gstack information and Linux sapsysinfo |
2023.12.14 | Rename SAP Support/Community Wiki to SAP Help Portal - Support Content |
2024.02.09 | SAP Community 2024 optimized content. |
2024.02.25 | Create sub-section SAP Kernel Snapshot Analyzer and sub-section Server snapshot |
2024.05.07 | Update sub-sections FSID and RTE with Cloud relevant details. |
2024.05.08 | SAP HANA On-Premise and SAP HANA Cloud separation in multiple sections. |
2024.06.27 | New home for openSAP courses. openSAP had been migrated to SAP Learning. |
2024.08.16 | Create sub-section Change support case details. |
2025.01.14 | Create sub-section Kernel Profiler. |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
27 | |
24 | |
23 | |
17 | |
14 | |
12 | |
10 | |
9 | |
8 | |
8 |