You can maintain the allocation limit parameter for a HANA tenant database, so from there, you can control and limit the maximum amount of memory that can be allocated per process. This will apply for all the services in the tenant database.
Depending on which SPS version installed, you can follow commands,
< SPS11
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'DATABASE', 'TENANT_DB')
SET ('memorymanager', 'allocationlimit') = '8888 WITH RECONFIGURE;
>= SPS11
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', 'Tenant_DB')
SET ('memorymanager', 'allocationlimit') = '8888' WITH RECONFIGURE;
To see the changes, use below command,
SELECT * FROM "SYS_DATABASES"."M_SERVICE_MEMORY";
Note
- For SPS09, you need to restart HANA database to take effect. For later version than SPS09, memory alignment will happen on the fly, but take some time. For immediate changes, a restart is still needed.
- See SAP Note 2175606 – HANA: How to set allocation limit for tenant databases
