HANA DB Long term usage

[former_member6619]

Dear community,

if I understand the situation correctly, there is no HANA DB equivalent of the ABAP stack transaction ST03N. Right? In other words there is no standard mean to provide me with a list of what, when or how the users used the HANA DB resources. Right? I am supposed to use the trace/audit trail to collect such an information. Right?

Therefore I am looking for a performance-cheap trace/audit configuration that would provide me with such a comprehensive overview. I would like to figure out a configuration, that I can turn on and keep on for a long time for all the HANA users, to collect a comprehensive insight into the HANA resources (DB tables? DB procedures? Authority checks?) used by the users without ruining my system performance. As I said above ST03N type of information - for business analysis, for performance tuning, for process optimisation etc.

Is any such thing even possible? Has anyone tried this before? How did it go?

Thank you for any inputs and insights. Discussion is very welcome!

cheers Otto

[lbreddemann]

SAP HANA does not provide this kind of user activity accounting.

From my point of view something like ST03N really only makes sense if there is a single system including the users to be considered. NetWeaver is such a monolithic system.

For SAP HANA the development approaches are different from that, starting with the focus on web-applications and micro-services and ranging towards "cloud ready" solutions with de-centralised user and identity management. The DB part of SAP HANA is commonly a shared resource in these scenarios that get consumed with a shared DB-user account.

Most applications try and deal with this challenge on a level where the application user concept is available (just like NetWeaver does it, too). In modern terms, this would be the "telemetry" of users which is driven from the application design rather than from the resource usage.

Anyhow, long story short: SAP HANA does not provide something directly comparable to ST03N.