Huge Pool/CSRowLocking in SAP HANA

[samo_drab]

Hello!

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.

After running

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?

Thank you.

Kind regards,

Samo

[HakanHaslaman · Accepted solution]

There was an issue which is fixed with the 122.21
Please check the SAP Note#2687490

[samo_drab · Accepted solution]

Thank You for your answer Hakan,

we later upgraded HANA to 2.0 SPS 03 and avoided this problem.

Kind regards,

Samo Drab