Lumira - How to determine resource utilization in HANA for every data set published.

[Former Member]

In this document we shall discuss on how to determine ‘how much Memory’ is being utilized for every data set published on to SAP HANA.

This document is in preview of the architecture of using SAP Lumira Server for HANA.

Where in you are using desktop to acquire data from Excel / CSV / other Non-HANA sources.  And you are publishing the data set along with visualization.

Scenario:   When we have multiple users publishing datasets with the source being Excel sheets / from other non-sap Hana source, a Number of tables gets created in HANA. Over the time it occupies disk space and the Memory in HANA DB.

So in order to predict / to evaluate the probable memory that each data set / all the data sets could occupy we need to understand how HANA deals with the Data sets.

As we all know for every data set published, Hana creates a Table and dumps the data there.

Each table occupies space and memory (as and when it’s used).

To assess the memory consumption, we need to look at the properties of the table in HANA.

How do we locate the data set table in HANA ?

Look at the schema of the user who publishes the data sets.  Hana by default prefixes the table name with “sapvi”.

Double click on the table and check the Runtime Information.

There it provides the memory consumption details for the table / data set.

In the Above Screen shot: 

Total memory consumption - is the compressed memory utilization.

Size on Disk – is the Space the data set occupies on disk.

Number of Entries – Number of rows in the table

Extrapolate these numbers to the user count and the probable data sets users would publish in a given time frame, you will get the statistics on Memory utilization and will provide the statistics needed for your capacity planning.

Bingo !  This should help you on Memory utilization exercise.