HANA History Memory Usage Data

[nicholas_chang]

Many questions and discussions are floating around on how to check History Memory Usage used by Hana Database. Managed to set up RCA Hana DB analysis on SOLMAN 7.1 and did a comparison between Memory Overview + Resource utilization with Hana Studio rev7.

SOLMAN RCA (database analysis)

Once configure, we can easily obtain the History data by inputting the timeframe, as the data are stored into the BW infocube in solman.

Database -> Host Memory

Database -> Hana Service Memory

Database -> Resource Usage

Hana Studio Rev7

In Hana Studio Rev7, we can check memory usage info via Memory Overview (which provide present data) and Resource Utilization (you can set the timeframe but data is not in tabular format, you need to browse on the graph to obtain the usage data)

Memory Overview

Resource Utilization:

As we can see, RCA in Solution Manager organize history data into chart and graph, and data is in tabular format which provide us a clearer picture as compared to the data presented by Hana Studio. It is much easier and extremely useful for solution architect or administrator to forecast the memory growth in future.

Cheers,

Nicholas Chang