How to analyze or trace the performance of an AMDP HANA SQL script in BW transformation?

[lumirion]

Hello community,

in a BW4-transformation we have written an AMDP (HANA SQL script) that we need to analyze in detail because of a performance lack.

Where and how can we analyze that script? Within HANA the script is represented by a database procedure, right? Shall we run the procedure using the PlanViz editor?

What is the best approach for a root cause analysis?

Kind Regards
Ertugrul

[former_member302041]

Hi,

I would suggest to do the following:

1. debug AMDP

2.examine the volume of in_table

3.if you see a problematic statement in debug then try to break down SQL code to subsets (if sql script is very complex)

4. run problematic subset in planviz (if conventional methods such as understanding sql code with eyes doesn't help)

BR,

[lumirion]

Thank you for the hint.