Skip to Content
0
Feb 14, 2018 at 04:54 PM

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

829 Views

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?