cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Database size growth

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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?

Former Member
0 Kudos

Thx jake, thats shows the current usage of each tables, i am looking for historic data, like last month the DB was 1TB and today its 1.2TB.

Former Member
0 Kudos

Ah. Ok. Check this link.

Think it will save 30 days. Not sure if longer than that by default: select SNAPSHOT_ID, HOST, TOTAL_SIZE, USED_SIZE from _SYS_STATISTICS.global_disks where USAGE_TYPE = 'DATA' ORDER BY SNAPSHOT_ID ASC;

Former Member
0 Kudos

hi jake,

The _SYS_STATISTICS.global_disks tables shows the usage of the entire disk which includes  LOG, DATA, TRACE, DATA_BACKUP and LOG_BACKUP, i am loking for just the DATA usage history .

Former Member
0 Kudos

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;