on 02-13-2014 9:35 PM
Is there history information inside the HANA database about the database growth( we are in sp6), if yes how can we find out , and is this a right query to get the current disk usage
select sum(allocated_page_size) from M_CONVERTER_STATISTICS
Thank you
Jonu Joy
If you go to the System Information tab in HANA Studio, there are several queries readily available to you. One is "Size of tables on Disk". Is this the info you are looking for?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
we can probably take the value from the daily backups, which is again not 100% accurate disk usage
SELECT a.entry_id, substring(to_timestamp(sys_start_time,'YYYY-MM-DD HH24:MI:SS.FF9'),1,10) as "DATE", round(sum(b.backup_size)/1024/1024/1024,0) as BACKUP_SIZE_GB FROM "SYS"."M_BACKUP_CATALOG" a, "SYS"."M_BACKUP_CATALOG_FILES" b where a.entry_id = b.entry_id and a.entry_type_name ='complete data
backup' and b.source_type_name='volume' and substring(to_timestamp(sys_start_time,'YYYY-MM-DD
HH24:MI:SS.FF9'),1,4) >='2014'group by a.entry_id, substring(to_timestamp(sys_start_time,'YYYY-MM-DD
HH24:MI:SS.FF9'),1,10) order by 1;
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.