Skip to Content
Author's profile photo Former Member

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

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      thank you

      Author's profile photo ANUKUL GIRADKAR
      ANUKUL GIRADKAR

      Thanks Vinay.

      Author's profile photo Former Member
      Former Member

      thank you Vinay ,this helps Beginners like me

      Author's profile photo Former Member
      Former Member

      Thanks Vinay