Syntax error Exporting SAP HANA system measurement using hdbsql

Exporting SAP HANA system measurement using hdbsql

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 −

Updated on: 2020-02-24T06:21:01+05:30

340 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements