Solution : https://service.sap.com/sap/support/notes/2112732 (SAP Service marketplace login required)
Summary :
The SAP HANA memory leak issue when using the 'use_in_memory_tracing' feature for the M_EXPENSIVE_STATEMENTS monitoring view has been addressed. The problem, prevalent from Revision70 due to storing extensive SQL statement data in memory, persisted until system restart or the revocation of the feature, causing significant memory allocation that wasn't released. This issue is fixed in versions Rev90 and later. For affected versions Rev70 to Rev85, users can circumvent the problem by disabling the feature in 'global.ini'. This setting reduces the overhead of managing performance data but should be turned off if experiencing memory issues.
Key words :
customer component han-db sap hana database priority correction, connection_id transaction_id statement_id db_user app_user start_time object_name, sps09 2123714 sap hana sps 08 database maintenance revision 85, 2144290 sap hana sps 08 database maintenance revision 85, 03 2163217 sap hana sps 08 database maintenance revision 85, 02 2107518 sap hana sps 08 database maintenance revision 85, high priority category program error validity, __%pdfstyle%__ / } symptom large amount, searching m_expensive_statments monitoring view collected, use_in_memory_tracing alter system alter configuration
Related Notes :
| 2144290 | SAP HANA SPS 08 Database Maintenance Revision 85.03 |
| 2163217 | SAP HANA SPS 08 Database Maintenance Revision 85.04 |
| 2066225 | SAP HANA DB: Known issues detected in SPS08 |
| 2093754 | SAP HANA DB: Known issues detected in SPS09 |
| 2123714 | SAP HANA SPS 08 Database Maintenance Revision 85.02 |
| 2107518 | SAP HANA SPS 08 Database Maintenance Revision 85.01 |