Size your BW on SAP HANA System
Determining needed hardware resources is usually done by the SAP hardware partner based on order information you submit. You provide this information using the SAP HANA In-Memory DB Sizing Guideline attached to SAP Note 1514966, SAP HANA 1.0: Sizing SAP In-Memory Database. SAP Note 1514966 also contains a script get_size.zip which will assist in calculating the data footprint of the SAP systems.
Alternatively, use the SAP QuickSizer tool to calculate the system memory requirements for your business warehouse data. You will find a questionnaire specifically for SAP NetWeaver BW powered by SAP HANA in this tool.
This table offers rough estimates of system hardware needs.
| Source Data footprint | HANA Appliance RAM required | HANA Appliance Disk required |
| 0.5 TB | 315 GB | 1.53 TB |
| 1 TB | 577 GB | 2.81 TB |
| 5 TB | 2.56 TB | 12.8 TB |
| 10 TB | 5.06 TB | 25.31 TB |
You can also calculate your own HANA RAM needs using one of these formulas:
RAM = (Source Data footprint - 50 GB) * 2 / 4 + 90 GB
or
RAM = ColumnStore Tables footprint * 2 / 4 + RowStore Tables footprint / 1.5 + 50 GB
Though the HANA database uses in-memory technology, disk space is required to store persistently data used in memory. The disk space must be large enough to hold:
Before- and after-image versions of data (2xRAM)
Database log (1x)
Operational space (1x)
At least one process image (in case of software failure) (1x)
One data export (1x)
So, the required size of disk space is 5x the size of the data in memory (RAM).
SAP Note 1637145, SAP BW on HANA: Sizing SAP In-Memory Database.
SAP Note 1702409, HANA DB: Optimal number of scale out nodes for BW on HANA.
Source: SAP HANA
Tags: BW HANA Sizing Info, BW on HANA Sizing Guide, SAP BW HANA Sizing Formula, HANA RAM needs for BW,