on 02-13-2014 4:18 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.