In recent years, we have been involved in the sizing of many BW on HANA systems. By far the most common case is the migration of an existing BW system to SAP HANA, referred to as the brownfield approach. The greenfield approach, in which a new BW is considered only on an SAP HANA system is less frequent. The transfer of a non-SAP data warehouse (DWH) to a BW system is rare, and we therefore address this approach only very briefly.
It is important to make sure that you size the database server for SAP HANA correctly because many mistakes can be made at this point. To help you avoid this, Marc Bernard, Product Manager SAP EDW, has written a very good blog detailing the most common errors made when sizing a BW on HANA system.
Blog: How NOT to size an SAP BW system for SAP HANA
2.1.1 Sizing when migrating an existing BW system
When migrating existing BW systems to SAP HANA, we strongly recommend that you use the ABAP sizing report for the database sizing. This report guarantees more accurate results and it is independent of the database compression. It can also incorporate the concept of non-active data, extended tables (for details on both topics, see Section 4.1), as well as future growth. SAP Note 2296290 and the attachments to that note describe in great detail how to run the report and what the functions of the individual parameters are.
The sizing report is called /SDF/HANA_BW_SIZING and is delivered from Service plug-in ST-PI 2008_1_7xx SP8 or ST-PI 740 SP01. The minimum prerequisite for the report is NetWeaver BW 7.0 SP1. For BW 3.5 systems, there is a separate report (SAP Note 2021372).
You can use different parameters for the report, which means that you have good control over the required resources and thus the load on the system. The report also saves you a lot of work by, for example, considering influences such as the conversion to unicode and any potential compression of the source database automatically. You can also run the report just for certain subareas of the system if you are planning to migrate only part of your system.
We recommend that you run the report and specify growth values based on your experience from previous years. This will give you a better overview of the hardware requirement for the coming years. Experience shows that the usual values for annual organic growth are between 10% and 30%. We also recommend that you activate consideration of non-active data.
With regard to the precision level, Low is sufficient to give meaningful results. It is only for small systems with databases of less than 500 GB that we recommend you set this level to High.
As already mentioned, SAP Note 2296290 contains very good documentation with an example. It gives a detailed description of all input parameters, how the tool works, and the results. Therefore, we will not provide any further explanations or an example at this point. We will restrict ourselves to typical questions or important information that we often receive despite using the detailed sizing report.
Up-to-date database statistics
We strongly recommend that you run the sizing report only with up-to-date database statistics because otherwise the results will be incorrect.
With regard to sizing, one aspect that is often forgotten is that every server has an operating system with a certain main memory requirement. 10% of the first 64 GB and 3% of the remaining main memory is reserved for the operating system. Furthermore, 50 GB must be reserved for services and caches for each server node. This results in the values shown in Table 2.1 for the different server sizes currently available. The sizing report takes these values into account fully automatically.
Table 2.1: Available main memory for different server sizes
Scale-out configurations for BW systems have at least three computer nodes. As a minimum, we strongly recommend two worker nodes for one master node. For more information about scale-out, see Section 2.4.2 on Scalability. Additional details about the sizing of the master node and the optimum number of scale-out nodes can be found in SAP Notes 1855041 and 1702409.
The sizing of the application server
With regard to the sizing of the application server, initially there is no change compared to a BW system with a different database. This applies to both ABAP application servers and JAVA application servers. You can use the Quick Sizer (see the next section) to work out the size for these servers.
Sizing additional applications and projects
If you want to operate further applications in BW (e.g., BPC) or on the same SAP HANA database (MCOD, see Section 2.4.3) in the future, you have to consider the main memory requirement for these applications in addition to the sizing of the BW system.
This also applies for new projects: in this situation, further data enters the system and you should include this in your considerations additively. If you are intending to consolidate multiple BW systems, you should also consider this additively.
A useful side effect of the sizing report is that it provides information about the volume of data in certain objects. In the case of very large row stores, change logs, or PSA tables, you can quickly see whether a system is well-maintained. For more on the topic of housekeeping, see Section 2.2.7.
Sizing reports for BW on HANA
Always use the latest version of the sizing report. The report is constantly being improved and only the most up-to-date version will guarantee the highest possible accuracy.
New sizing report for BW/4HANA:
Sizing Report for BW on HANA (for BW 3.5 Systems):
SAP HANA Academy: “BW on HANA” sizing video
This video provides a step-by-step procedure for using the sizing report: https://youtu.be/-qq6d92YJek
2.1.2 Sizing a new BW on HANA
When you are sizing a new system for BW on HANA, you should use the Quick Sizer (http://service.sap.com/quicksizer). There is a special version of the Quick Sizer for SAP HANA-based systems (http://service.sap.com/hanaqs). The tool will help you not only to determine the correct size for the database server but also the correct dimensions for the application server where necessary. SAP provides very good and detailed information and videos on this topic and therefore we will not provide any further explanations here.
Helpful information about sizing
The overview on SAP Service Marketplace provides information on how to use the Quick Sizer as well as other guidelines on the topic of sizing:
SAP Active Global Support: Sizing Approaches for SAP HANA—Lessons Learned:
SAP HANA Academy sizing videos
Sizing SAP HANA:
Quick Sizer overview:
Sizing a non-BW data warehouse for BW on HANA
Let us assume you have an existing data warehouse that is not based on BW technology. You want to convert this system into a BW on HANA. There are two options for the sizing:
1. Quick Sizer (see the previous section)
2. Manual sizing
SAP Note about BW on HANA sizing
The manual sizing is described in detail in the attachment to SAP Note 1637145:
What you should know
An important prerequisite for using the formula in SAP Note 1637145 is the existence of comparable data models.
If, for example, you are planning in BW to store data multiple times persistently but do not do this in your current system, you should include this in your considerations because otherwise, there is a risk that you might size the system too small.
The same applies in the reverse situation—that is, if you break down the data model and the existing redundancies, then you need less space in the future BW system. In this book, we will show you how to virtualize data layers because there are special new options for this with BW on HANA.
2.1.3 System measurement
Figure 2.1: System measurement
Because there are now more than a thousand live BW systems on HANA, the number of requests for system measurement and information about how to perform such measurement is rising. In SAP HANA Studio, customers can generate a measurement report at any time. This report records the size of the maximum main memory used by the database in the last twelve months. The following PDF document on SAP Service Marketplace provides very good information on this topic for customers.
Information about and links to system measurement
System Measurement for License Audit:
SAP System Measurement Guides:
White paper: SAP HANA Memory Usage Explained:
Allocated Memory Pools and Allocation Limits:
FAQ: SAP HANA Memory:
Alle Inhalte. Mehr Informationen. Jetzt entdecken.
et.training - Ihre Lernplattform für SAP-Software
- Zugriff auf alle Lerninhalte1
- Regelmäßige Neuerscheinungen
- Intelligenter Suchalgorithmus
- Innovatives Leseerlebnis
- Maßgeschneidere Lernpfade
- Zertifikate & QA-Tests2
1 Sie erhalten Zugriff auf alle Lerninhalte. Online-Trainings, Zertifikate sind NICHT Teil der Flatrate.
2 Weitere Informationen auf Anfrage.