HANA Heap Memory Allocation

[Former Member]

One of our HANA databases has the heap memory allocation as follows (please look at the attachment).

Can someone explain me the heap memory object Persistency/Container/VirtualFile? This is occupying around 500GB if the space.

Is there a way to clear this space, if it is not normal?

Thanks,

Mrutyumjai

[former_member183326]

What revision are you running?

[Former Member]

Hi Michael,

We are running 1.00.097.03.1443520413 (fa/newdb100_maint_rel).

Thanks.

[Former Member]

I also have system using most of the space in the RAM.

[former_member183326]

Is this constant or was it just during the time you executed the query. Can you also try querying the last 2 weeks of memory allocator use? My feeling is this is not the actual cause of the memory usage and may have only been for that moment and time when your queried it. Use the hana_memeory_history sql and do it for two weeks. This will allow you to see if this allocator has indeed grown and used more than normal.

[former_member183326]

This means nothing to be honest. If you can give some memory allocators this would be helpful. Try querying the from note 1969700. Also why are you looking this up? Did you see an OOM on your system? What reason do you have to believe that there is actually memory issues on your system?

[Former Member]

Thank you Michael.

I was looking into the memory usage because I observed the following:

The indexserver has allocated most of the RAM (2TB), but the database is using around 1.4TB of it. Is there a way to release this space? I know there are blogs or notes saying it is normal to have indexserver allocate most of the space.

Mu doubt is with the system component using 795GB of space.

I have checked our other databases and system never used more than 250GB of space.

795GB seems like a memory leak.

Thanks,

Mrutyumjai

[Former Member]

790 GB my bad, not 795GB

[former_member183326]

Can you show me the Memory allocator which are consuming the most memory? Use the memory overview query from note 1969700

Also to check if there is indeed a leak we need to see a rise in the allocator over a period of time. Again I will need you to check which allocator have risen over a 2 week period. Use the memory queries from note 1969700. You can change the time period in the modification section of the query

[Former Member]

I think the memory allocators show the used memory of the database and not the resident memory!

Is this true?

I see a row store table using around 180GB of memory.