How to capture the memory consumption of a HANA obeject?

[former_member183494]

Hi experts,

Is there any tools or tables can delicately capture the memory consumption of a stored procedure  or a HANA view?

Recently, I encounter a HANA performance issue and need to know how much memory the SP took during runtime.

Thanks for your help in advance.

BR,

Molly

[duncanspeidel]

Hi Molly,

In the HANA studio open the admin prospective and go to the performance tab.  This tab provides a lot of details about the current HANA load.  While you procedure is running you should check 'Blocked Transactions' and 'Expensive Statement Trace'.  Those areas might offer a hint.

You could start the HANA admin console, HDB admin, and take a performance trace restricted to the user running the procedure.

You could attach the debuger, from HANA studio, to the session that calls you procedure and step through it.

I know the statistics servers uses _SYS_ STATISTICS for reporting, but I don't know which table or view has information about procedures.

Best regards,

Duncan

[former_member183494]

Thanks for your reply. But I still have some queries.

>>In the HANA studio open the admin prospective and go to the performance tab.  This tab provides a lot of details about the current HANA load.  While you procedure is running you should check 'Blocked Transactions' and 'Expensive Statement Trace'.  Those areas might offer a hint.

-->If the SP take a very short time, we cannot capture the memory consumption, right?

>>You could start the HANA admin console, HDB admin, and take a performance trace restricted to the user running the procedure.

-->Would you please give me more details about how to see the memory in the Perf trace?

What I only know is I can see the process steps and time there.

>>You could attach the debuger, from HANA studio, to the session that calls you procedure and step through it.

-->Sorry, I also didn't find the place to see the memory usage.

I know the statistics servers uses _SYS_ STATISTICS for reporting, but I don't know which table or view has information about procedures.