Skip to Content
Jan 28, 2020 at 07:53 PM

How to get the Buffer Cache Hit Ratio from the Hana database



We are trying to monitor a SAP Hana database, we would like to measure the buffer cache hit ratio of the database regularly.

Is it possible to calculate this metric with a SQL query or is there a table/view where the metric is directly stored (like in Oracle database with the view SYS.V_$SYSMETRIC_HISTORY) ?

Thank you for your help !