Question Re: HANA Statement execution statistics in Technology Q&A

HANA Statement execution statistics

Former Member — Tue, 29 Aug 2017 23:09:28 GMT

Many systems have a method to profile a command or block of commands. I am looking for one that can instrument HANA SQL statements.

How can one get execution stats for a HANA SQL statement (e.g. a call procedure or a dynamic execute sql) in terms of

number of rows read

memory consumed

cpu consumed

Then, if yes, can it be applied on a statement block, like, begin instrumentation ...stuff... end instrumentation? It would be great if there was an example to follow.

Regards

Dinesh

Re: HANA Statement execution statistics

lbreddemann — Wed, 30 Aug 2017 01:55:25 GMT

Please do some own research first. The Performance and Troubleshooting guide as well as the HANA Administration guide contain information on this topic. Also, there had been lots of blogs and discussions here in the community - a quick search will get you good leads here, too.

Re: HANA Statement execution statistics

former_member208389 — Wed, 04 Oct 2017 15:45:10 GMT

you can use Visualized Plan from HANA studio to display HANA SQL execution plan, inlcude CPU time, records returned from each HANA execution step and network traffic