a month ago
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.