Skip to Content
avatar image
Former Member

How to find out memory consumption for table in HANA without load it into memory

Hi,

To determine the memory consumption for a table in HANA, you can query table M_CS_TABLES, however, it requires load table into memory first, I just wonder if there has another table store memory consumption information for all HANA tables regardless it load into memory or not. Below is screenshot for one of table in my system, since that table is partially loaded into memory, "Total Memory Consumption (KB):" tell me the memory consumption of the portion load into memory, what I am looking for is something like "Estimated Maximun Memory Consumption (KB)" which provides me total memory consumption for that table including portion doesn't load into memory, of course I can use this Esitmated information, but consider I have close to thousand tables in my HANA system already, it's not pratical to check tables one by one.

Thanks,

Xiaogang.

ss_table.png (5.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 16, 2014 at 07:48 AM

    Hi,

    You can get the details from M_CS_TABLES View, just run the below query

    SELECT SCHEMA_NAME, TABLE_NAME, ROUND(SUM(ESTIMATED_MAX_MEMORY_SIZE_IN_TOTAL)/1024/1024/1024) AS "SIZE IN GB"

    FROM M_CS_TABLES

    WHERE SCHEMA_NAME = 'SCHEMA_NAME'

    GROUP BY SCHEMA_NAME, TABLE_NAME

    ORDER BY TABLE_NAME

    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded