cancel
Showing results for 
Search instead for 
Did you mean: 

Index server is running out of memory

Former Member
0 Kudos

Dear experts,

I am using HANA DB tenant.

Indexserver is running out of memory.

Which parameter should I increase to resolve this error?

By the way, global allocation limit is set to full 1 TB

Regards,

Fadzly Iqbal

Accepted Solutions (1)

Accepted Solutions (1)

former_member182967
Active Contributor
0 Kudos

Hi Zulfadzly,

From the SYSTEMDB, execute the following command:

<= SPS10

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'DATABASE', '<tenant_DB>') SET ('memorymanager', 'allocationlimit') = '<allocate_MB>' WITH RECONFIGURE;

>= SPS11

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', '<tenant_DB>') SET ('memorymanager', 'allocationlimit') = '<allocate_MB>' WITH RECONFIGURE;

Even through the configuration change takes effect immediately, a database restart is suggested as mis-handling of allocation memory could cause OOM and corrupt the data in memory which is mentioned in note 2175606 – HANA: How to set allocation limit for tenant databases

Regards,

Ning

Answers (0)