Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

HANA Runtime Dump Main Parts

|| 0

HANA Runtime Dump Main Parts
Stechies

What are the important sections or parts of SAP HANA Runtime Dump?

SOLUTION

The SAP HANA runtime dump consist many sections which are described in the table of content in the beginning of dump.

The table below is the list the most important section are:

Section Description Details Available
[BUILD] Build information Information about SAP HANA version
[SYSTEMINFO] System information System information such as Instance name, operating system version
[STACK_SHORT] Short call stacks Short call stacks for all threads, important to understand current thread activities
[LIMITS] Limits Operating system related limitations related to memory, files and processes
[STACK_FULL] Full call stacks Full call stacks for all threads, also provides further details on top of [STACK_SHORT] that may sometimes be helpful for a better understanding
[STATISTICS] Statistics data Content and data for various SAP HANA monitoring views such as DATABASE_STATISTICS, M_CONDITIONAL_VARIABLES, M_PROCESS_MEMORY, M_VOLUME_IO_DETAILED_STATISTICS,
M_VOLUME_IO_TOTAL_STATISTICS, M_EVENTS, M_HEAP_MEMORY, M_JOBEXECUTORS, M_MEMORY_OBJECTS, M_MUTEXES, M_READWRITELOCKS, M_SEMAPHORES, M_LOG_BUFFERS,
M_LOG_SEGMENTS, M_SAVEPOINTS, M_CONNECTIONS, M_PREPARED_STATEMENTS, M_TRANSACTIONS, M_SESSION_CONTEXT, M_MVCC_OVERVIEW, M_BLOCKED_TRANSACTIONS,
M_SQL_PLAN_CACHE_OVERVIEW or their SAP HANA internal pendants
[PROCESS_INFO] Process information General overview of processes running on operating system level
[INDEXMANAGER_WAITGRAPH] Wait graph for index handles and other internal locks Internal SAP HANA lock dependencies can be found in this section (in dot format).
[SAVEPOINT_SHAREDLOCK_OWNERS] Owners of shared ConsistentChangeLock locks In case a savepoint is blocked in the waitForLock phase , the blocking activities can be found in this section.
[OS_MEMORY] Operating system information about memory General overview of operating system memory information, including the configuration of critical aspects like transparent huge pages or ulimit
[IPMM_MEMORY] Interprocess memory management information In this section you can find SAP HANA IPMM information including memory allocated by different SAP HANA processes, allocation limit, used and allocated memory and a memory flight recorder.
[THREADS] Running threads

Information about running threads including:

  • Thread type
  • Transaction ID
  • Update transaction ID
  • Application information
  • Connection ID
  • User names
  • Executing database requests
  • Thread detail
  • Thread method


Advertisement
Advertisement
Advertisement