Exporting SAP HANA system measurement using hdbsql

SAP HANASAPSAP Basis

To export this details you first need to have INIFILE ADMIN system privilege. Following hdbsql command can be used −

SELECT ROUND(SUM(INSTANCE_TOTAL_MEMORY_USED_SIZE) / 1024 / 1024 / 1024, 0) AS DATABASE_MEMORY_USED_IN_GIGABYTES FROM
M_HOST_RESOURCE_UTILIZATION RU, M_LANDSCAPE_HOST_CONFIGURATION HC
WHERE RU.HOST = HC.HOST AND HC.INDEXSERVER_ACTUAL_ROLE IN ('MASTER','SLAVE');

You can also run this command in SQL editor to get this details −

raja
Published on 05-Feb-2018 20:33:35
Advertisements