SAP HANA database performance issue | Generic Symptoms

Please visit our blog to get more knowledge.

The purpose of this video is to help you to find the probable root cause of some generic problems.

*** Component memory allocation *****

SELECT host, component, sum(used_memory_size) used_mem_size FROM PUBLIC.M_SERVICE_COMPONENT_MEMORY
group by host,component ORDER BY sum(used_memory_size) desc;

*** Active statements ***

Select "LAST_EXECUTED_TIME","APPLICATION_SOURCE", "CONNECTION_ID","STATEMENT_ID","STATEMENT_STATUS","STATEMENT_STRING", "USED_MEMORY_SIZE", "LAST_ACTION_TIME" from "SYS"."M_ACTIVE_STATEMENTS"

[gundem]

hi,

Priority:
4 (High)

Alert ID:
105

Alert Name:
Total Open Transactions Check

Description:
93% out of 64000 reached for service hostname:31011

The check monitors the number of open transactions per service

User Action:
Double check if the application is closing the connection correctly, and whether the high transaction load on the system is expected.



How fix it? Do you know?

[koteswararao]

One particular table is using high memory consuming how to analyze

[SnSActivityHub]

Need some real time or scenerio based videos

[koteswararao]

How to analyze a particular trace file like index server trace do we need to read all the 30000 lines or any technique there