How to find the size of the HANA DB
Here are two simple SQL querry that can help you to find it out the size of HANA DB .
we have two aspects here :-
to find column store utilization :-
SELECT round (sum(MEMORY_SIZE_IN_TOTAL)/1024/1024) AS “Column Tables MB” FROM M_CS_TABLES;
to find row store utilization :
SELECT round (sum(USED_FIXED_PART_SIZE + USED_VARIABLE_PART_SIZE)/1024/1024) AS “Row Tables MB” FROM M_RS_TABLES;