Database Growth Report with HANA DB

[Former Member]

Can anyone help me with the following"

I have the EWA report with me.

How to create a DB growth (monthly). I am not sure how the content should be aligned. If anyone has a report please share.

[yakcinar]

Hello David,

You can use the pdf in the link for calculating the size history as workaround.

https://wiki.scn.sap.com/wiki/download/attachments/247399467/DVM_HANA%20how%20to%20backup%20size.pdf...

Open SAP Note 1969700 in SAP Service Marketplace . Download the attachment "SQL Statements.zip" to your local computer and open it. This zip-file contains many text files. Search for "HANA_Backups_BackupRuns.txt".

Use the SQL script in this file by modifying as described in the PDF file and get the backup size history.

I modified it like below.

As you mentioned better version of DB size history is coming with EWA report.

There is no place on DBACOCKPIT like anydbs or on HANA Studio to find the size history.

And I asked this to OSS also. They told me that they cannot tell me how to get the HDB size history like EWA reports.

Regards,

Yuksel AKCINAR