HANA Statement execution statistics

[Former Member]

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

[lbreddemann]

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.

[former_member208389]

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