Question Re: HANA tools - SQL statements analysis in Technology Q&A

HANA tools - SQL statements analysis

former_member201054 — Mon, 27 Jul 2020 04:24:38 GMT

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

Re: HANA tools - SQL statements analysis

former_member644293 — Mon, 27 Jul 2020 05:13:47 GMT

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,

Re: HANA tools - SQL statements analysis

hariom_garg — Tue, 04 Aug 2020 10:42:44 GMT

Hi,

Go for below SAP Note:-

1969700

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

Re: HANA tools - SQL statements analysis

dvankempen — Wed, 05 Aug 2020 07:09:10 GMT

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.

Re: HANA tools - SQL statements analysis

dvankempen — Wed, 05 Aug 2020 07:12:41 GMT

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.

Re: HANA tools - SQL statements analysis

sumitjais — Wed, 05 Aug 2020 11:04:08 GMT

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.