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: #, Table Types in HANA : 1> Column Store tables 2> Row Store tables.
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:, 26/03/2014 The total amount of memory in use by SAP HANA is referred to as its Used Memory.
This is the most precise indicator of the amount of memory that the SAP HANA database uses at any time.
When used: To understand the current used memory in HANA when HANA alerts shows usage greater than licensed memory.
Understanding memory usage by components will.
You can check the delta merge configuration in SAP HANA cockpit by opening Configuration of System Properties indexserver.
Since the default value for the frequency of delta merges is already 1 minute (check_interval = 60.
000 ms), optimization with regards to memory consumption can only be done by adjusting the decision function of the corresponding merge type and the.
SAP Cloud Platform, SAP HANA Service on AWS and GCP: SAP HANA SQL Reference Guide for SAP HANA Platform.
Cloud * Versions.
Cloud * * This version is out of mainstream maintenance.
For more information, see the Product Availability Matrix (PAM).
M_CS_TABLES System View.