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"
Total Memory Consumption of All Columnar Tables:
SELECT round(sum(MEMORY_SIZE_IN_TOTAL)/1024/1024) AS "Column Tables MB"
Total Memory Consumption of All Row Tables
SELECT round(sum(USED_FIXED_PART_SIZE +
USED_VARIABLE_PART_SIZE)/1024/1024) AS "Row Tables MB"
Total Memory Used:
SELECT round(sum(TOTAL_MEMORY_USED_SIZE/1024/1024)) AS "Total Used MB"
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.