Skip to Content
-1

Statistics table for HANA CALC VIEWs

Aug 22, 2017 at 02:24 PM

192

avatar image
Former Member

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.

Thanks

Srini

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Aug 23, 2017 at 12:52 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded