Skip to Content

HANA Statement execution statistics

Aug 29, 2017 at 11:09 PM


avatar image

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.



10 |10000 characters needed characters left characters exceeded

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.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Xiaofan Wu
Oct 04, 2017 at 03:45 PM

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

10 |10000 characters needed characters left characters exceeded