HANA Backup Size Estimation

Requirement : We want to check the backup size, so that we can plan for the backup disk requirement.
Prerequisite: We need database user with CATALOG READ or DATA ADMIN assigned.
Steps:
Connect to the required system via HANA Studio.
Open Administration perspective,  You can open it from Window -> Open -> Perspective -> Administration Console
Execute following SQL:
SELECT SUM(allocated_page_size) FROM M_CONVERTER_STATISTICS
Above SQL will let us know the total backup size in bytes:
If you want to see the size of individual HANA service then execute following SQL.
SELECT volume_id, sum(allocated_page_size) FROM M_CONVERTER_STATISTICS GROUP BY volume_id;
The size displayed is in BYTES. Above shown Volume_ID are mapped with services(shown below).
HANA Server
Volume ID assigned
Example file name
Name Server – Topology
0
Complete_databackup_0_1
Name Server – Volume
1
Complete_databackup_1_1
Index Server
2
Complete_databackup_2_1
Statistics server
3
Complete_databackup_3_1
XS engine
4
Complete_databackup_4_1

Leave a Reply