Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Memory_TopConsumers

Hi,

Due to performance issues on our present situation in landscape I have checked SQL HANA_Memory_TopConsumers . I see result

MEMORY_REDUCTION_APPROACHES as Application data management and archiving .

Can anyone suggest on Application data management and archiving mean here ,Is it partioing date. Any procedure to follow to ? Also suggestion require on heap area and row store.

fyi..

30003    indexserver    Column store    EKPO    15.14    3.75

61.33    Size of table EKPO in column store    Application data management and archiving

30003    indexserver    Column store    /POSDW/TLOGF    13.11    3.24        71.69    Size of table /POSDW/TLOGF in column store    Application data management and archiving

30003    indexserver    Column store    /POSDW/PLOG1S    12.11    2.99        74.68    Size of table /POSDW/PLOG1S in column store    Application data management and archiving

***********

PORTSERVICEAREADETAILSIZE_GBSIZE_PCTCUM_SIZE_PCTDESCRIPTIONMEMORY_REDUCTION_APPROACHES
130003indexserverHeap areaPool/malloc/libhdbcsmd.so34,868,638.63Column storeCleanup, compression and archiving of column store tables
230003indexserverHeap areaPool/ColumnStoreTables/Main/Dictionary/RoDict28,667,0915.73
330003indexserverHeap areaPool/PersistenceManager/PersistentSpace(0)/DefaultLPA/Page27,936,9122.64Page cacheSpace is automatically reclaimed if required
430003indexserverHeap areaPool/malloc/libhdbcsapi.so24,816,1428.79Column storeCleanup, compression and archiving of column store tables
530003indexserverHeap areaPool/RowEngine/SQLPlan23,095,7134.51SQL cacheSee SAP Note 2124112
630003indexserverHeap areaPool/RowEngine/SQLPlan22,795,6440.15SQL cacheSee SAP Note 2124112
730003indexserverHeap areaPool/ColumnStoreTables/Main/Compressed/Indirect19,824,945.06
830003indexserverColumn storeVBUP19,064,7249.78Size of table VBUP in column storeApplication data management and archiving
930003indexserverHeap areaPool/Statistics163,9653.75Internal statistical informationOpen SAP incident in case of very large and rising size
1030003indexserverHeap areaPool/ColumnStoreTables/Main/Uncompressed15,473,8357.58
1130003indexserverColumn storeEKPO15,143,7561.33Size of table EKPO in column storeApplication data management and archiving
1230003indexserverHeap areaPool/ColumnStoreTables/Main/Rowid14,93,6965.02
1330003indexserverHeap areaPool/Statistics13,83,4168.44Internal statistical informationOpen SAP incident in case of very large and rising size
1430003indexserverColumn store/POSDW/TLOGF13,113,2471.69Size of table /POSDW/TLOGF in column storeApplication data management and archiving
1530003indexserverColumn store/POSDW/PLOG1S12,112,9974.68Size of table /POSDW/PLOG1S in column storeApplication data management and archiving
1630003indexserverHeap areaPool/ColumnStoreTables/Main/Index/Single10,842,6877.37
1730003indexserverHeap areaPool/malloc/libhdbcstypes.so9,382,3279.69Column storeCleanup, compression and archiving of column store tables
1830003indexserverColumn storeEDID49,382,3282.02Size of table EDID4 in column storeSAP Note 706478 (archiving and cleanup options)
1930003indexserverColumn store/POSDW/AGGRTI7,311,8183.83Size of table /POSDW/AGGRTI in column storeApplication data management and archiving
2030003indexserverRow storeRow store fragmentation6,81,6885.51Row store fragmentationSee SAP Note 1813245 and reorganize row store

Regards,

DK

Former Member
Not what you were looking for? View more on this topic or Ask a question