Skip to Content

Statistics table for HANA CALC VIEWs

We have a calculation views in HANA , where users are querying using Tableau.

Are there any tables/views in HANA which gives the below information.Mainly we are looking for statistics on calc views.

1) Which user ran the query against a calc view with date and time.

2) How much memory consumed/used by that query.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 23, 2017 at 12:52 AM

    This question (basically you're asking for the SAP BW query runtime statistics but on HANA level) has been asked and answered before.

    A little search can go a long way here.

    Generally, HANA does not keep track of every single query execution. What you can do, however, is activating the EXPENSIVE STATEMENT trace and set the lower limit for recorded statement runtime to a reasonable level that allows you to review long running statements.

    With that, you'll get a good grip on what queries put what kind of load onto your system. In order to use this trace and to evaluate the trace output you may want to chat to your HANA admin or review the relevant sections in the documentation and/or SAP notes.

    Add comment
    10|10000 characters needed characters exceeded