Skip to Content
avatar image
Former Member

Need to Retrieve Performance Details from System tables..

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 06, 2014 at 09:15 AM

    Hi,

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

    Regards,

    Michael

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 06, 2014 at 09:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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