Skip to Content
0

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

Feb 14 at 04:54 PM

81

avatar image

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?

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

1 Answer

Best Answer
Lars Breddemann
Feb 14 at 11:09 PM
1

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0