/scripts/ahub.form.attachments.js
0

Hana memory allocation and cache

Feb 09, 2017 at 10:04 AM

64

avatar image

Hi,

We are having troubles with memory usage in a BW on Hana environment, with Hana DB, v. 112.06, with 1TB of memory available.

In TopConsumers information, in first position we have the allocator "Pool/PersistenceManager/PersistentSpace/DefaultLPA/Page" with more than 200GB used. As described in note 1999997 - FAQ: SAP HANA Memory, this fact should not be relevant, since this is a cache, that should be liberated when other process need it. Our problem is that some memory expensive process are failing due to memory allocation problems, and the cache isn´t being liberated. We can see how process take memory, and when reachs the DB limit, process is cancelled (we have statement_memory_limit=0 and statement_memory_limit_thresold=0 ). If after that we go to TopConsumers sql , we have the allocator with the same memory used, so it hasn´t released the memory when other process needed it.

We think it´s an application error, any ideas?

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers

Skip to Content