Memory consumption of SP

[Former Member]

Hi,

Is there any way to check the memory consumption of stored procedure in HANA studio ?

Appreciate the responses.

Regards

Bala

[pfefferf]

Hello Bala,

one way is to check the memory consumption via the VizPlan functionality.

Paste your procedure call statement in a SQL console, right click on the statement -> Visualize Plan -> Execute.

Regards,

Florian

[Former Member]

Thanks a lot Florian !

[former_member182302]

From which version is the vizplan on SP si getting supported? I get this error for Procedure call statement

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna,

Plan Viz tool supports from SP 1.8, to execute SQL statements, I remember in my last project was on SP1.8, and i was able to use PlanViz by right click on select statement.

but we didnt used Plan Viz much on calling procedures in sql editor.

Now I am on SP 10, and plan viz tool is working for SQL, call procedure statements by R/Click and execute the plan viz.

In below link Ravi mentioned Plan viz is available from SP 6.0

Below screen shot from SP 1.10 . Hope the information is useful...

Message was edited by: Lajwanth Singh

[former_member182302]

Thanks for sharing. Been using VizPlan for SELECT statements but never on SP . I was checking the same and currently the system is on SP10 but it still get the above error.

I will check further

Regards,

Krishna Tangudu