Memory utilization

[former_member465305]

Hi All,

We want to automate a script where we want to get monthly load

on HANA for every month through HANA studio or Putty.

We are using below script to get the data manually.

select host, to_char(TIME,'DD-MM-YYYY HH24') time_1, max(cpu), round(max(memory_used)/1024/1024/1024,2) from "_SYS_STATISTICS"."HOST_LOAD_HISTORY_HOST_BASE" where host = 'host31r1n2' and TIME between '<From-Date>' and 'To-Date' and (to_char(time, 'HH24:MI') like '%:00' or to_char(time, 'HH24:MI') like '%:30' or CPU > 60 or memory_used > 644245094400) group by host, to_char(TIME,'DD-MM-YYYY HH24') order by time_1;

Kindly check below details.

HANA DB Version : 1.00.122.02.1473345179

HANA Architecture : Multi tenant on multi host

Can anyone suggest how can we achieve this.