Hi Prasath, I didn’t quite get your requirement, but you can fire a query against M_CS_TABLES in HANA studio to get the information required.
The Delta and main storage depends upon if the table is loaded to the memory (delta and main).
45 rows SAP HANA Platform: SAP HANA SQL and System Views Reference.
0 SPS 03 * #, 34 rows Column name Data type Unit Description ; HOST: VARCHAR(64) Host name : PORT: #, SAP HANA provides separate measurements for Column Store tables and Row Store tables.
Table Types in HANA :.
Note: The M_CS_TABLES and M_CS_COLUMNS views contain a lot of additional information (such as cardinality, main-storage versus delta storage and more).
For example, use the following query to obtain more information:, 45 rows SAP HANA SQL Reference Guide for SAP HANA Platform.
Cloud * Versions.
Cloud * * This #, When the SAP HANA database runs out of allocatable memory, it will try to free up some memory by unloading unimportant data.
Even column store tables are unloaded, column by column, based on a least-recently-used order, up to a preset lower limit.
AS “MB Used” FROM M_CS_TABLES GROUP BY SCHEMA_NAME ORDER BY “MB Used” DESC.
26/03/2014 SAP HANA database tracks the highest-ever value of Used Memory reached since the database was started.
In fact, this is probably the single most significant memory indicator that you should monitor as an overall indicator of the total amount of memory required to operate the SAP HANA database over a long period of time.
Provides runtime data for column tables.
M_VOLUME_SIZES – Volume sizes used by SAP HANA servers M_WORKLOAD – Database workload collected every minute M_XS_APPLICATIONS – Applications deployed and running in SAP HANA XS, SAP Tables Tables are used to store data.
It is a part of database and contains various fields.
In this section you can browse the list of SAP tables and their fields by Software components & modules wise.
From the table page you will get details about each table and the fields of that table.