SAP HANA tools

[DanielFe]

Dear Expert

Is there any SAP HANA tools for checking the query which was took long time for execute. Because it makes another process in SAP so slowly.

Thank You

[SriKrishna]

Hi,

this requires an end to end review.

1. is the query that is running slow, is slow at all times of the day or during certain peak times.

2. when the slow transaction runs, check STAD on SAP Application server to find out the degradation in performance is on DB side or App Side. if query is slow at certain times of the day, compare STAD at that time with the time of good run.

3. if the increase is seen in processing time or CPU time in STAD, do a trace to find out the programming issue. If the increase is on DB Time, we have to check on HANA DB side.

4. how are we certain that, it is making the other SAP process slow. does the other SAP process run faster, when its run independently instead of running parallel with the slow query.

5. when the slow running query is run, could you please check CPU and Memory usage on HANA to find out which of them is increasing.

6. Review SQL Cache and find if the query execution plan is suboptimal.