SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
Hadoop App
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Hadoop App
Stay Connected
Search Topics
Course Index
SAP HANA Administration - Part 1
Course Overview
1. Introduction
2. SAP HANA Installation Overview
3. SAP HANA Sizing
4. Pre-Installation Steps for SAP HANA
5. Installation of SAP HANA with SAP HANA Lifecycle Management Tools
6. What is Next?
<< Previous
Next >>
3.8 SAP HANA Sizing Using Quick Sizer

Quick Sizer is a universal tool for sizing SAP systems and products. This is a web-based tool and is free of cost.
SAP HANA Database can also be sized using SAP Quick Sizer!
The Quick Sizer calculates:
  1. CPU
  2. Disk
  3. Memory
  4. I/O resource categories
It calculates these based on throughput numbers and the number of users working with the different SAP solutions in a hardware- and database-independent format.

In this chapter we will see how to use Quick Sizer to calculate HANA size.

1. Create a New Project in Quick Sizer and select suitable option
  1. Start the QuickSizer tool by clicking this link. Note that you need acount in SAP service market place to download this tool.
  2. Give any project name and click on “Create Project”
    SAP HANA Administration Course
  3. In SAP Quick Sizer multiple predefined scenarios can be selected, e.g.:
    • Rapid Deployment Solutions
    • SAP NetWeaver BW powered by SAP HANA
    • Standalone HANA
    For each of the scenarios, the expected compression of the data is different.
  4. Choose Standalone HANA

SAP HANA Administration Course

2. Specify source data footprint and active user details
  1. 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.
  2. Enter the Source data footprint (in GB) and number of concurrent user in the tool. In this example, we assumed that the source data footprint is 100 GB and no of user is 500.
    SAP HANA Administration Course
  3. 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. SAP strongly recommends using the default value if you do not have reliable information justifying a different compression factor.

3. Questionnaires - Specifics for SAP NetWeaver Powered by SAP HANA
In case you are doing sizing for SAP BW powered by SAP HANA, you need to provide some more information. The Quick Sizer questionnaires contain questions and algorithms specific to this particular scenario.  
The Quick Sizer questionnaire enables you to specify the size of InfoCubes ?and Data Store Objects, along with average and peak load times, user groups, data upload information, and row and column footprints and compression. For example:
SAP HANA Administration Course
4. Calculate result
  1. Click on “Calculate result” and Quick Sizer will determine the system resources required to support the new solution based on the entered parameters

SAP HANA Administration Course

  1. Below image shows the results for the example scenario.

SAP HANA Administration Course

5. Get the Right Amount of Hardware
Once you have calculated the correct values for memory, CPU, and disk space to support your implementation needs, you can check for sample configurations at
You can also contact a trusted hardware vendor that can work with you to evaluate your sizing calculations to determine which of their offerings are suited to your configuration requirements.

Note: Before purchasing hardware, consider also evaluating a new KPI called single computing unit (SCU) performance. SCU refers to the processing power of a single computing unit within a system. Hardware that has good SCU performance helps ensure faster process response times. More information about SCU performance can be found in SAP Note 1501701.

<< Previous
Next >>
 © 2017 :, All rights reserved.  Privacy Policy