HANA tools - SQL statements analysis

[former_member201054]

Hi Experts,

What are all the available HANA tools for analyzing the over Memory & CPU consuming SQL statements identified.

I would appreciate all your help for providing details.

Thanks in advance

[dvankempen]

You asked a question. Don't forget to mark the answer that helped you most as correct. Thanks!

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

[dvankempen]

Please consider to review any of your 156 questions asked and accept answers. This rewards the efforts of community members spending time on your queries and also helps to make finding answered questions easier.

[sumitjais]

Hi daniel.basis,

I believe you have been asking the similar questions putting in different words for sometimes and are getting same response every-time. Are you not convinced with the earlier ones? A little experiment with the mini checks would have helped you in better ways.

https://answers.sap.com/questions/13076400/hana-memory-consumption-reasons-post-analysis.html

https://answers.sap.com/questions/13041093/root-cause-of-hana-cpu-utilization.html

https://answers.sap.com/questions/13082375/hana-daily-monitoring-troubleshooting-sql-statemen.html

denys.kempen : 564 the number of qns .156 is the responses primarily because the information to own qns were submitted as answers.

[former_member644293 · Accepted solution]

Daniel,

HANA Mini checks can used to check this.

Refer OSS#1999993,1969700 for further details.

https://blogs.sap.com/2015/05/15/keeping-your-hana-system-healthy-with-mini-checks/

Regards,

[hariom_garg]

Hi,

Go for below SAP Note:-

1969700

Having all SQL statements which can help in analyzing CPU & Memory realted issues