Skip to Content

How to find which tables and views are being read by users in HANA?

I'm trying to determine which calculation views users are accessing in our HANA sidecar system so that I can determine if there are any tables we can stop replicating. I'm familiar with BW statistics that does a great job of recording this information but I can't find anything similar in HANA (similar to this question https://archive.sap.com/discussions/thread/3758009). We are running HANA 1.0 SPS 12 so we have the embedded statistics server (https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/1.0.12/en-US/d234eedbd29510148efbf332391de7fd.html) available. I have explored the _SYS_STATISTICS views and tables but so far have not found anything that gives me the usage information I'm looking for.

Has anyone else figured out how to determine which calculation views and associated underlying tables are being read by users?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 14 at 11:09 PM

    The concepts for monitoring in SAP BW (an application) and SAP HANA (a database management system) are considerably different as these two systems operate on different levels in the technology stack.

    SAP HANA does not by default record extended statistics for every single database request. You can, however, setup tracing and auditing depending on your needs.

    In order to get an idea of what tables are actually being used, setting up table auditing is the best approach. It ensures to capture all accesses, the timestamp and associated user account and keeps the information in an easy to analyze table.

    Add comment
    10|10000 characters needed characters exceeded