The SAP HANA database has generated out-of-memory (OOM) trace files in the trace directory (/usr/sap/<sid>/HDB<nr>/<nodehostname>/trace) using the following naming convention: Example for an actual file name: You experience memory shortages and you have generated a runtime dump as described in SAP Note 1813020.

The SAP HANA database has generated composite OOM trace files in the trace directory (/usr/sap/<sid>/HDB<nr>/<hostname>/trace); Example for an actual file name: indexserver_<hostname>.<port number>.rtedump.<timestamp>.compositelimit_oom.trc. Read …

Jan 5, 2014 · If you see OOM errors and you have done (1-5) then the chances are that your model is materializing a large data set. Because temporary tables in HANA aren't compressed, they can be 5-10x larger than the equivalent column table, which means that you can balloon large volumes of RAM.

After upgrading to SAP HANA SPS 08 and above you see Out of Memory errors and composite oom trace file dumps on HANA Entries are written into the trace files similar to this:

Explore How to Analyze Out of Memory (OOM) Dumps at SAP Learning. Find out more!

Jan 24, 2019 · An SAP HANA runtime dump is a text file that provides various information about the current state of the SAP HANA database. HANA runtime dumps are frequently used to troubleshoot technical issues like system hangs, high memory consumption etc.

Trace files with the following naming convention are created when there is a memory problem. For more details on the dump, see Which types of dumps can be created in SAP HANA environments? Example: in the administration editor: 1999997 - FAQ: SAP HANA Memory.

System-side slow performance, slow individual statement performance, and OOM problems are issues that you might experience while using the SAP HANA database. For each section, this document will cover the known symptoms and the corresponding troubleshooting steps to follow depending on the causes.

Dec 30, 2019 · In this blog I will explain with 2 examples (OOM dump and indexserver crash) which tools you can use to analyze them and what you have to watch out for. High level: creation of a runtime dump

You can use this tool (typically with guidance from the SAP Product Support team) to create runtime dump files and analyze the details of memory consumption. If necessary, dump files can be sent to Product Support for further analysis. The following SAP Notes may be helpful in solving some problems and when analyzing memory issues with hdbcons.