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
|
Reference
: https://help.sap.com