Solution : https://service.sap.com/sap/support/notes/2088349 (SAP Service marketplace login required)
Summary :
SAP Note describes an issue where memory usage in SAP HANA increments consistently, even when idle, as seen through the monitoring view m_heap_memory. The high memory use pertains particularly to the Pool/JoinEvaluator/JERequestedAttributes/Results or Pool/ValueArray allocators. This situation persists despite clearing the SQL plan cache. The problem occurs with systems on revisions below 84, especially when running SQL executed calculation views with currency conversion. Resolved in Revision 84, an interim solution involves resetting execution settings, which could impact performance adversely.
Key words :
customer component han-db sap hana database priority correction, high priority category program error validity, __%pdfstyle%__ / } symptom memory usage, sap notes 2066225 sap hana db, alter system clear sqlplan cache, allocator pool/joinevaluator/jerequestedattributes/results, / __%pdfstyle%__font-size, pool/joinevaluator/jerequestedattributes/results, software component version references, query monitoring view m_heap_memory
Related Notes :
2066225 | SAP HANA DB: Known issues detected in SPS08 |