2175606 – HANA: How to set allocation limit for tenant databases


You want to manage and control the memory usage of your multiple-container system by configuring global allocation limit for individual tenant databases.



HANA Platform Software Support Package Stack 09



You can use allocationlimit in [memorymanager] of indexserver.ini file to limit the maximum amount of memory that can be allocated to all processes of a tenant database.
For example, execute below command from the system database:

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'DATABASE', 'MYDB') SET ('memorymanager', 'allocationlimit') = '8192' 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.
After restart you can use SQL query:


to confirm the changes with systemdb connection.
Alternatively you can check it with column “Allocation Limit(MB)” in Sevices tab under Landspace in HANA studio by logging on to the tenant DB.



MDC, GAL, Global Allocation Limit, Multitenant Database Containers

Leave a Reply