Skip to Content

Memory utilization

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers