HANA Performance Analyse on stored procedures

[reuscpe]

Dear Community,

i want to analyse serveral high load situations within our HANA Database.
My problem is, the situations the high-load is generated is located within a stored procedure and the analysis tools only show me the complete procedure but not the underlaying SQL commands.

As you can see the workload analysis does not give me a detailed look in what is happening but just shows the procedure.

Question:

Are there any options to performance-trace / workload analyse a stored procedure ?

thanks you & best regards
Peter

[RishabBucha]

Hello Peter,

I am sure you might have explored this, but did you try to user planviz to analyze your query.

There is a blog which I think is useful and provides details on performance.

https://blogs.sap.com/2018/04/29/analyzing-sql-execution-with-the-plan-visualizer-planviz/

Regards

Rishab