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

[jasonmuzzy]

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?

[RobMoore]

Hi Jason - did Lars' Table Auditing suggestion help with this? We are facing the same issue of wanting to know which HANA tables are in use etc.

Thanks in advance!

[lbreddemann · Accepted solution]

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.

[jasonmuzzy · Accepted solution]

Thank you, Lars! I'll look into table auditing.