Skip to Content

HANA Tenant Memory Utilization

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

pastedImage_0.png (29.2 kB)
pastedImage_1.png (30.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 20, 2016 at 01:04 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 18, 2016 at 06:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Aug 18, 2016 at 02:05 AM

    Hi Zulfadzly,

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

    Regards,

    Ning


    1.png (20.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 18, 2016 at 08:08 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 22, 2016 at 02:32 PM

    Hi Iqbal,

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

    Regards,

    Avinash

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.