HANA Tenant Memory Utilization

[Former Member]

Dear experts,

We are using HANA MDC.

Our HANA server physical memory is 1 TB.

From below screenshot, we can know that Used memory is 317GB.

My question is how can we know the used memory of our HANA tenant?

For example, if I open the console of HANA tenant(DB2), it also show used memory 317GB out of 1 TB.

Appreciate your advice.

Regards,

Fadzly Iqbal

[Former Member · Accepted solution]

Hi Iqbal

SAP HANA system with multitenant database containers feature can contain multiple tenant databases. All tenant databases in the same system share the same system resources (memory and CPU Cores). So what is displayed under SAP HANA Used Memory is for entire HANA System, display for option via tenant DB is not an option available as memory is used by Processes or services

However, each tenant database is fully isolated with its own database users, catalog, repository, persistence (data files and log files) and database services so that for example, you can run both SAP Business Suite and SAP Business Warehouse (BW) in one SAP HANA system.

With multitenant database containers, you can assign system resource limits (memory and CPU cores) to each tenant database so that higher workload on one tenant database cannot impact other tenant databases. You can also change the allocated resources at any time, based on changing needs of each tenant database.

For more information please click on the below Blog

https://blogs.saphana.com/2015/01/27/sap-hana-multitenant-database-containers/

Hope this answer your question,please mark as correct answer.

Thankyou,

Avinash

[Former Member]

Hi Iqbal,

Please close this tread if your question is answered...thank you

Regards,

Avinash

[Former Member]

Hi Zulfadzly,

You can manage the memory allocation limit by changing the configuration file.

ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'DATABASE', 'Tenent Db') SET ('memorymanager', 'allocationlimit') = 'memory in kb' WITH RECONFIGURE

Or just search allocation limit in configuration tab of hana studio and set the memory accordingly.

With reconfigure does not let you to restart the system.

You can also set the CPU cores used by each tenant DB.

Thanks

Nelekanth

[ashok_oleti]

Hi Zulfadzly,

It could also be possible that the memory allocation limit for the tenant databases is not set so each tenant database is assuming that it has 1 TB memory and consuming 317GB/370GB memory.

What value do you see for the parameter "allocationlimit" under indexserver.ini-->[] memorymanager -->allocationlimit for your tenant Database "DB2@MDC""

Cheers,

Ashok O

[Former Member]

Hi Fadzly, hi Ashok,

actually the "SAP HANA Used Memory" section of the Admin Overview shows the memory usage of the whole system, not any specific tenant, even if you open the tenant-specific overview. As Ning already pointed out, you can see the usage of the single services under Landscape -> Services.

The view "SYS_DATABASES"."M_SERVICE_MEMORY" might be helpful as well.

Best regards,

Stefan

[former_member182967]

Hi Zulfadzly,

The used memory can be see from Landcape tab -> Services after logon that tenant DB.

Regards,

Ning