Peak Memory by HOST for Column store in BWP after RISE

[SAPSupport]

We are seeing lower values in TB for Peak Memory by HOST for Column store in BWP after RISE

PFA document with Screenshots and below is the SQL that we used.

SELECT CURRENT_DATE, CURRENT_TIMESTAMP, HOST, COMPONENT, 
ROUND(SUM(EXCLUSIVE_SIZE_IN_USE)/DIGITS, 0,ROUND_HALF_UP) MEM_GB 
FROM M_HEAP_MEMORY WHERE EXCLUSIVE_SIZE_IN_USE > DIGITS GROUP BY HOST, COMPONENT;

HOST After RISE:  vhhpgbphdb01 & vhhpgbphdb02 - and peak memory column values showing around 10 or 11 TB

HOST Before RISE:  hpibphdb11 & hpibphdb12 - peak memory column values showing around 1 TB

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

It looks that you are checking memory usage from host level, and this usually cannot give the real value for current memory usage of HANA DB.

There is a HANA DB function names Resident Memory, which will load 90% or higher memory of host into HANA DB level in advance.

In this case you will see a obvious high memory usage from host level, but actually HANA DB is not using so much.

You need check the Used Memory from HANA Studio to know how many memory HANA DB is using, the details about this is mentioned in note:

2081473 - SAP HANA Resident Memory: High Memory Usage