Tenant memory consumption

[Former Member]

Hello,

How can I see the memory consumption of a single tenant?

I have two tenant but I can't differenciate the memory consumed for each one.

On Systemdb view and S00 and H00 system information screen I see the same memory. 94GB.

Thanks a lot.

[AtulKumarJain · Accepted solution]

Hi Ruben,

Please follow the below tutorial.

Monitor Status and Resource Usage of Tenant Databases - SAP HANA Administration Guide - SAP Library

BR

Atul

[Former Member · Accepted solution]

Hello Atul,

Is it only possible with Hana cockpit?

You monitor the overall availability, resource usage, and performance of tenant databases from the system database using the Manage Databases app of the SAP HANA cockpit

I don't believe that I can't see the usage of a single tenant with hana studio.

Regards

[Former Member · Accepted solution]

Hello,

It's just execute the sql SELECT * FROM "SYS_DATABASES"."M_SERVICE_MEMORY"; on each tenant.

Thanks

[Former Member]

Hi Ruben,

Can you check the SAP note 2175606 - HANA: How to set allocation limit for tenant databases if it is useful?

Thanks,

Jagadish.