cancel
Showing results for 
Search instead for 
Did you mean: 

query to find the memory usage during peek periods

Former Member
0 Kudos

hi

Would anyone have a query to find the memory usage on HANA DB during different time periods( between 9:00AM to 12:00 non)

Thank you

Jonu Joy

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

this query seems to work

select top 100 round(TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as

"Used Memory GB", HOST, SERVER_TIMESTAMP  from _SYS_STATISTICS.HOST_SERVICE_MEMORY where

SERVER_TIMESTAMP between '10.02.2014 09:00:00' and '12.02.2014 15:00:00'

order by TOTAL_MEMORY_USED_SIZE desc