Description | Screen Shots | ||
---|---|---|---|
Start the QuickSizer tool: https://websmp109.sap-ag.de/quicksizer Create New Project | |||
Choose Standalone HANA HANA memory sizing is derived from the size of the tables in the source database. Note that only tables must be taken into account. Space for indexes, temporary table spaces etc. must be excluded. Run the sizing script attached to SAP note 1514966 to obtain correct size information from your source database system catalog. The number of users is optional. If you enter a user number, Quick Sizer checks if the CPU requirements are met by certified hardware configurations. | |||
Specifics for Standalone HANA
Enter the compression factor, i.e. the ratio of the sizes of uncompressed data tables (without their indexes) on the source database and the memory requirements of these tables in HANA. We strongly recommend using the default value if you do not have reliable information justifying a different compression factor. | Input: Output: | ||
Specifics for SAP NetWeaver Powered by SAP HANA
| Input: Output: |
Description | Screen Shots | ||
---|---|---|---|
Download “get_size.zip” from SAP Note 1637145 | |||
Extract and copy the DB specific scripts under below path, /usr/sap/<SID>/sys/global Note: Same folder where the rowstorelist.txt file is stored | |||
Edit the “get_mss_size.sql” script file to add, In line 1 of the script, replace “SID” with the SID of your system At the bottom of the script, replace “schema” in the command exec sp_hana_sizing ‘schema’ by the schema name of your system | |||
Run the get_mss_size.sql script, SID: S01 Schema Name: S01 | Output: |
Sizing Calculation:
SAP has provided the sizing formula based on the output from the sql script. Use the output from sql script to calculate the RAM size and Disk
Size.
RAM = (colstore tables footprint * 2/4 + rowstore tables footprint /1.5) * C1) + 50 GB (HANA Cache and Additional Services)
e.g: RAM: (4.09 *2/4 + 8.33/1.5)*5) + 50 GB = 88 GB
Disk = (Disk – Persistence (4*RAM) + Disk – Log (1*RAM))
e.g: (4*88 + 1*88 = 440 GB)
SAP HANA Sizing Using ABAP Report:
Starting with the BW version 7.3 SP5 you can run the SAP BW on SAP HANA DB platform, In order to migrate an existing SAP BW system from any DB platform to SAP HANA, SAP recommends using the new ABAP sizing report /SDF/HANA_BW_SIZING for SAP BW.
The pre-requisite for ABAP report /SDF/HANA_BW_SIZING is support tool plug-in version ST-PI 2008_1_7XX SP06
This report obtains list of tables from the ABAP dictionary table (DD02L)
For more details, please refer SAP BW on HANA Sizing Report: https://websmp209.sap-ag.de/~sapidb/012006153200000051552013E/SAP_BW_on_HANA_Sizing_Report_V1_4.pdf
Description | Screen Shots |
---|---|
Login to SAP BW System and run t-code SE38 > Enter the report name “/SDF/HANA_BW_SIZING” and execute | |
This is the sample input & output screen for the ABAP report | Input: Output: |
Input:
I am using below input fields specific to the case below, one can change the inputs as per the business requirements
Enter the inputs as below,
Store output in file = X File Name = Extent.ext (Default File Name) Number of parallel procs = 50 Suppress Table with Zero size = X Precision = Low (Low precision with take minimum time to execute Future Growth = X Number of Years = 3 Relative Growth in % and Growth value = 100 GB
Output: RAM: 60 GB Disk: 300 GB (5 times RAM) | Input: Output: |
Business benefits
The important benefit for the right amount of SAP HANA sizing is to achieve the unparallel speed to access and output real-time data. SAP HANA’s in memory storage capacity allows the processing of massive quantities of real-time data to provide the immediate results to end users because of the huge amount of memory.
The right sizing at the start of the project will help in getting the ROI on SAP HANA and help in reducing the future maintenance cost because of the data volume growth over the period of time.
The SAP HANA sizing will help in identifying the requirement of single node system or scale out system requirements based on the existing
system data volume and future growth analysis
Conclusion
The need for SAP HANA sizing is very important in the initial phase of SAP HANA implementation. Improper sizing or missing sizing exercise will lead to various issues in terms of performance and the whole purpose of HANA implementation will be lost.
References
SAP Note 1736976 - Sizing Report for BW on HANA
https://websmp209.sap-ag.de/~sapidb/012006153200000051552013E/SAP_BW_on_HANA_Sizing_Report_V1_4.pdf
SAP Note 1514966 - SAP HANA 1.0: Sizing SAP In-Memory Database
How To Size SAP BW on HANA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |