capturing HANA DB growth

[former_member248450]

Dear Experts,

Recently we have started conversion activities in  SAP HANA systems.

Can anyone  of you suggest, on how to capture the DB growth. Also we want to capture the Top 100 tables which grew and if possible certain objects too.

Jun

[michael_kozlowski · Accepted solution]

Maybe this link will be helpful to capturing growth of HANA DB and tables

https://hcp.sap.com/content/dam/website/saphana/en_us/Technology%20Documents/HANA_Memory_Usage_SPS8....

[davidebruno]

In my experience (2 years of SAP Hana), I usually capture the growth of the database with the size of the data backup.

This is the real very helpful information regarding the size of the database.

With SAP note 1969700 , you can use the script to understand the TOP 10 tables size in memory

[Bojan-lv-85]

i suppose Jun's goal is to capture the sizes of individual clients,...

[former_member248450]

In the documents, i didn't see any way to capture size of tables specific to one client in SAP. Is it even possible to get that information? please let me know.

[Bojan-lv-85]

Hello Jun,

no, this is not possible with the SQL Statement collection mentioned.

BR, Bojan

[Former Member]

You can display the sizes of the largest tables separated by clients using SQL: "HANA_Data_Clients_CommandGenerator" (SAP Note 1969700).

[former_member183326]

You could try the SQL scripts from Note 1969700