Skip to Content

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 :-


1.column store

2.Row store

to find column store utilization :-


SELECT round (sum(MEMORY_SIZE_IN_TOTAL)/1024/1024) AS “Column Tables MB”  FROM M_CS_TABLES;


sample output-01.png

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;



/wp-content/uploads/2014/03/sample_02_416765.png

4 Comments
You must be Logged on to comment or reply to a post.