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;


13 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. BASIS LABS on January 6, 2014 at 8:27 AM

    useful post to all thank you

     
  3. yektek on January 7, 2014 at 1:38 PM

    very useful information swathi

     
  4. SinduBindu com on January 23, 2014 at 1:53 PM

    super article Thank you

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

    nice information thanks a lot

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

    good information thanks for this

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

    Thank you for the tips Latha Pallavi

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

    nice post Latha Pallavi

     
  9. SWATHI BOPPUDI 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

     
  10. Malathy m on April 19, 2016 at 1:07 PM

    Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP SD

     
  11. sushma on August 11, 2016 at 10:52 AM

    Thanks for sharing this Informative content. Well explained.Got to learn new things from your Blog on SAP SD.
    SAP SD

     
  12. sushma on September 18, 2016 at 12:45 PM

    Great place to learn about the new things and got great knowledgeSAP MM Training in Chennai

     
  13. sanayamohit on October 7, 2016 at 10:32 AM

    Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP MM.
    SAP MM

     

Categories