Memory Questions on HANA

[former_member514240]

Hi ,

We are on HANA version (2.00.024.02.1525857514 (fa/hana2sp02)) and OS version RHEL 7.5(Maipo).

We are seeing some misbehaviour of HANA system as below.

As per HANA studio -- SAP HANA Used Memory is 284GB.

but if we manually check for the column + ROW + code relevant tables it is very less just ~80GB.

We are checking values using below queries.

Code and Stack Size:

SELECT round(sum(CODE_SIZE+STACK_SIZE)/1024/1024) AS "Code+stack MB"
FROM SYS.M_SERVICE_MEMORY;
Total Memory Consumption of All Columnar Tables: SELECT round(sum(MEMORY_SIZE_IN_TOTAL)/1024/1024) AS "Column Tables MB"
FROM M_CS_TABLES;
Total Memory Consumption of All Row Tables SELECT round(sum(USED_FIXED_PART_SIZE +
USED_VARIABLE_PART_SIZE)/1024/1024) AS "Row Tables MB"
FROM M_RS_TABLES;
Total Memory Used:SELECT round(sum(TOTAL_MEMORY_USED_SIZE/1024/1024)) AS "Total Used MB"
FROM SYS.M_SERVICE_MEMORY;
the current values are as follows:
code 14GBcoloumn 59GBRoW tables 2GB
Total Used memory as per query : 302GB
CODE + Column + ROW ~ 80GB but total memory is around ~300GB
Could you please help why such big difference in the memory? We are thinking after analytic execution HANA is not releasing memory?
Could you please help us in this concern?
Thanks and ReagrdsSampath R.

[HakanHaslaman]

I would recommend to open a support incident, so the Product Support can investigate and analyze the issue directly on your system.