2014-09-11 - 14160.100 - Rel Notes - HANA Sizing - Release 001 #BIReleases2014

Release Notes

14160.100 - Hana Sizing - BPD

Admin Info



Purpose
Need to Delete PSA tables and do compression on cubes and to run scripts to get HANA expected sizing in BPD.
Release No
001
Submitted on
09/11/2014
Submitted by
Uday Kumar P
Environment
BW Development(BPD)
Sent To
Mark Harris
Transport Status
NA

Transport and Technical Objects


None

Release Notes

For Requestor

1. Parameters for BW HANA Sizing Program:

BPD Parameters.jpg

2. Sizing Recommendation For BPD (Before deletion of PSA tables and Change Log Tables):


Parameters/Estimates
Value
Minimum total memory requirement
69 GB
Time considered for growth
3 Years
Assumed yearly growth rate
33.0 %
Estimated size after 1 year(s)
75 GB
Estimated size after 2 year(s)
83 GB
Estimated size after 3 year(s)
94 GB

The Hana Sizing Output in BPD before deletion of PSA Tables and Change log Tables is shown in the attached HTML document:
HANA Sizing(Before Deletion of PSA & Change log Tables) - BPD.htm

Summary of the HANA Sizing Program Output:
BPD.JPG

3. Sizing Recommendation For BPD (After deletion of PSA tables and Change Log tables):


Parameters/Estimates
Value
Minimum total memory requirement
68 GB
Time considered for growth
3 Years
Assumed yearly growth rate
33.0 %
Estimated size after 1 year(s)
74 GB
Estimated size after 2 year(s)
82 GB
Estimated size after 3 year(s)
92 GB


The Hana Sizing Output in BPD after deletion of PSA Tables and Change log Tables is shown in the attached HTML document:

HANA Sizing(After Deletion of PSA & Change log Tables) - BPD.htm

Summary of the HANA Sizing Program Output:
BPD1.JPG

Reference Document(Specification)

2014-09-02 - 14160.100 - Spec - HANA Sizing