## 1 SAP HANA Troubleshooting and Performance Analysis Guide
With SAP HANA, you can analyze data at incredible speeds, for example, with scans of 1 billion rows per second per core and join performance of 10 million rows per second. However, such results are only possible if the system is monitored and performance issues are kept to a minimum.
This guide describes the measures you can take to identify and resolve specific issues and shows you how to enhance the performance of your SAP HANA database in the following areas:
- Host resources (CPU, memory, disk)
- Size and growth of data structures
- Transactional problems
- SQL statement performance
- Security, authorization, and licensing
- Configuration.
A separate guide aimed at developers is available, focusing on performance issues and steps you can take to enhance the performance of your SAP HANA database: SAP HANA Performance Guide for Developers.
## Prerequisites
- This guide assumes knowledge of the relevant functionality of the SAP HANA database (knowledge which can be gained from HANA training courses such as HA100, HA200).
- Access to the administration tool SAP HANA cockpit (or alternatively SAP HANA studio) is required.
## Overview
## Analyzing Generic Symptoms
This section of the troubleshooting guide helps you to find out about causes of generic problems such as:
- slow system-wide performance
- slow individual SQL statements
- frequent out-of-memory (OOM) situations
Furthermore, you are directed to sections of this guide that contain more specific root causes.
SAP Note references lead you to possible solutions.
Analyzing Generic Symptoms [page 8]
## Root Causes & Solutions
In this section of the troubleshooting guide you find concrete root causes for problems together with possible solutions. Some of the areas covered are:
- Memory Problems
- CPU Related Root Causes and Solutions
- License Issues
- Statement Performance Analysis
You may find the SAP Notes very useful for solving your issue as they contain detailed explanations and step-by-step instructions, for example.
Root Causes and Solutions [page 65]
## Tools and Tracing
This section of the troubleshooting guide presents monitoring tools which can be used for analyzing and tracing certain issues.
## Tools and Tracing [page 237]
Apart from those more specific monitoring tools discussed here, there are important tools for administrators and developers in general:
- SAP HANA cockpit
 Tip
For the documentation of the latest SAP HANA cockpit support package (SP), see https:// help.sap.com/viewer/p/SAP_HANA_COCKPIT
- SAP HANA database explorer SAP HANA Database Explorer
- SQL analyzer Analyzing Statement Performance
- Support Log Assistant
The Support Log Assistant is a tool that allows you to automatically scan and analyze text files such as logs, configuration files or traces. The tool will then suggest solutions to known issues found in the files and highlight important details that it finds. The tool is integrated into the incident logging procedure and is also available as a standalone tool; the following link is to a Support Portal getting started page which also gives direct access to the Support Log Assistant.
Support Log Assistant
## Alerts
Alert checkers run in the background and you are notified in case of potentially critical situations arising in your system. In the SAP HANA cockpit, you can easily see in which areas you might need to take some action.
Alerts Reference [page 302]
## SAP Notes
SAP Notes are used to give detailed supplementary customer support information in addition to the formal set of published documents. This troubleshooting guide includes many references to relevant SAP Notes. The
Alerts reference section, for example, gives links to corresponding notes for each system alert. Some other FAQ-format SAP Notes which you may find useful are listed here:
- SAP Note 2000003 - FAQ: SAP HANA
- SAP Note 1999997 - FAQ: SAP HANA Memory
- SAP Note 2186744 - FAQ: SAP HANA Parameters
## Guided Answers
Guided Answers is an interactive online support tool to help users to diagnose and solve problems using decision trees. It covers many SAP products including SAP HANA and offers a set of step-by-step problemsolving online documents each one designed to address a specific topic. Guided Answers is available in the SAP Support portal at the following address:
https://ga.support.sap.com/dtp/viewer/
This troubleshooting guide includes links to specific trees where relevant. The following tree is a general high-level troubleshooting tree for SAP HANA:
https://gad5158842f.us2.hana.ondemand.com/dtp/viewer/#/tree/1623/actions/21021
## Further Resources
The following SAP HANA documents are important resources for working with SAP HANA and are often referred to in this guide:
- SAP HANA Administration Guide
- SAP HANA SQL and System Views Reference
In particular, the SAP HANA Administration Guide gives general details on using the administration tools SAP HANA cockpit and SAP HANA studio.
There is a central online portal for a variety of support resources for SAP products which is available from the SAP ONE Support Launchpad Software Downloads : https://launchpad.support.sap.com/#/ softwarecenter
In the SAP Community Network (SCN) you can find many support resources online including wikis, blogs, reference materials and so on. This SCN wiki page, for example, provides links to many specialist topics: SAP HANA In-Memory Troubleshooting Guide .
Both SAP HANA Academy and SAP Support offer Y ouT ube channels with a wide range of support materials in video format:
- https://www.youtube.com/user/saphanaacademy
- http://www.youtube.com/user/SAPSupportInfo