We are running HANA rel. 1.00.122.13.1507793622 and between 25. and 26. 10. we started to experiencing Out of Memory Events. Data in BW system wasn't transfered correctly from ERP system.
SELECT TOP 15 MS.HOST, MS.SERVICE_NAME,MH.CATEGORY, MH.INCLUSIVE_SIZE_IN_USE, MH.EXCLUSIVE_SIZE_IN_USE
FROM M_HEAP_MEMORY MH, M_SERVICES MS
WHERE MH.PORT = MS.PORT AND
MH.HOST = MS.HOST AND
MS.SERVICE_NAME = 'indexserver'
ORDER BY 4 DESC
we found out, that majority of memory (almost 80 Gb) was consumed by Pool/CSRowLocking. According to Note 1999997 we should check the locking, but table was empty. But (according to the note) in case of permanent sizes of more than 50 GB a more detailed analysis is useful.
Any thoughts, ideas?