SAP HANA database performance issue | Generic Symptoms

Published: 11 February 2022
on channel: SAP Administration learning platform

6,482

152

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"

Watch video SAP HANA database performance issue | Generic Symptoms online without registration, duration hours minute second in high quality. This video was added by user SAP Administration learning platform 11 February 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,482 once and liked it 152 people.

11,526

489