Skip to Content
0
Nov 05, 2018 at 08:34 AM

Huge Pool/CSRowLocking in SAP HANA

220 Views

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