We can help. Together we learn....

How to find the size of the HANA DB

by vinaysingh | Tuesday, August 06, 2013 in |


 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;

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;


8 comments:

  1. magnifictraining on August 12, 2013 at 4:31 PM


    Fantastic article ! You havemade some very astute statements and I appreciate the the effort you have put into your

    writing. Its clear that you know what you are writing about. I am excited to read more of your sites content.

    Bigdata training

     
  2. Unknown on January 6, 2014 at 8:27 AM

    useful post to all thank you

     
  3. Unknown on January 23, 2014 at 1:53 PM

    super article Thank you

     
  4. Keylabs SAP training on February 5, 2014 at 10:58 AM

    nice information thanks a lot

     
  5. yektek training on February 12, 2014 at 2:20 PM

    good information thanks for this

     
  6. yektek.com on March 4, 2014 at 3:43 PM

    Thank you for the tips Latha Pallavi

     
  7. yektek.com on March 29, 2014 at 1:51 PM

    nice post Latha Pallavi

     
  8. Unknown on December 4, 2014 at 5:02 PM

    Hi,
    Very nice to share info here.The best sap hana online trainers are providing online training on sap hana through with real time projects by experienced experts
    sap hana online training
    also with real time projects and provides server access to practice

     

Post a Comment

Subscribe to: Post Comments (Atom)

Categories