SAP HANA database performance issue | Generic Symptoms
Please visit our blog to get more knowledge.
rupeshschavan.blogspot.com
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"