Skip to Content
0

Database Growth Report with HANA DB

Jan 17, 2017 at 09:40 AM

723

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Yuksel AKCINAR Jan 18, 2017 at 05:15 PM
1

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?version=1&modificationDate=1432636156000≈i=v2

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


hdbsizehistory.jpg (72.4 kB)
Share
10 |10000 characters needed characters left characters exceeded