Skip to Content
0

Memory utilization

Dec 05, 2017 at 10:28 AM

18

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers