How to check the M_CS_TABLES in SAP HANA Posted on Aug 06, 2012 at 02:09 PM | 635 Views.
Answers Include Comments Get RSS Feed.
Hi All, How to check the M_CS_TABLES in SAP HANA.
I guess the delta and Main storage will created in run time.
So, in that case can we debug it or check the M_CS_TABLES table.
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 #, 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, Provides runtime data for column tables.
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.
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.
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.