Need to Retrieve Performance Details from System tables..

[Former Member]

I want to retrieve the performance details (execution time , no of tables affected , no of rows selected) of a procedure that i execute, I tried searching the

System Tables and Monitor Views  but i am not able to find out into which table all the performance data get stored for the procedure i execute.

Message was edited by: Tom Flanagan

[Former Member]

Hi Vignesh ,

Primarily i would recommend you to go through this video

This is like a base for monitoring topics :  Monitoring SAP HANA - Checklist | SAP HANA

Thanks,

Razal

[Former Member]

Ya but to do it i require administrator access but i want to access the data from system tables as a normal user and want to retrieve the execution time , procedure name etc and store it in a seperate table or variable .

[Former Member]

Hi,

You don't really need to be a system for this part , you can ask your admin to create a user with
MONITORING (Pre-existing role ) in HANA ,which is more that enough .

Thanks,

Razal

[Former Member]

Hi Razal

But i want to access it without having a MONITORING role Privelage, My Requirement is for every procedure i call i need to retrieve the execution time, the procedure name etc.. from the system tables and store it in a table and then display it.

Thanks

Vignesh

[michael_devine]

Hi,

Maybe the performance trace can help: 1787489 - SAP HANA Database: Performance Trace

Regards,

Michael

[Former Member]

Hi

I am not able to understand could you be a bit specific

Regards,

Vignesh