Howto calculate the average daily data change rate in HANA?

[Former Member]

I was asked about how much (in percent) of a specific HANA database changes each day. This lacks of course a precise definition for "data change rate". So lets assume the HANA database consists of only 1 huge table. If each day x% of its rows are modified, i.e. all the values for these x% rows is changed, which metric of the HANA database could I query to determine x?

Or is there no such metric, and I have to resort to some kind of rule of thumb like: The database is y GB in size and it writes z GB of logs each day, therefore the change rate is z/y ?

Regards,

Mark

[former_member182302 · Accepted solution]

Hi Mark,

can you have a look on these tables.

M_CS_TABLES

M_RS_TABLES

M_RS_MEMORY

M_TABLEs.

Please Note : Also understand about Delta Merge in the below link:

So depending on your settings and information from the tables will give you a starting point to create the procedure to compute the average daily data change.

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Hello Krishna,

looks like there is only this generic information from the monitoring views and no out-of-the-box metric to see the HANA change rate. Therefore I had a deeper look into this topic and wrapped my findings up into a blog:

Regards,

Mark