Memory Sizing SAP HANA Project FAQ

Memory Sizing
Memory sizing is the process of estimating, in advance, the amount of memory that will be required to run a certain workload on SAP HANA. To understand memory sizing, you will need to answer the following questions:

1. What is the size of the data tables that will be stored in SAP HANA?
You may be able to estimate this based on the size of your existing data, but unless you precisely
know the compression ratio of the existing data and the anticipated growth factor, this estimate
may only be partially meaningful.

2. What is the expected compression ratio that SAP HANA will apply to these tables?
The SAP HANA Column Store automatically uses a combination of various advanced compression
algorithms (dictionary, LRE, sparse, and more) to best compress each table column separately. The
achieved compression ratio depends on many factors, such as the nature of the data, its
organization and data-types, the presence of repeated values, the number of indexes (SAP HANA
requires fewer indexes), and more.

3. How much extra working memory will be required for DB operations and temporary
computations?
The amount of extra memory will somewhat depend on the size of the tables (larger tables will
create larger intermediate result-tables in operations like joins), but even more on the expected
work load in terms of the number of users and the concurrency and complexity of the analytical
queries (each query needs its own workspace).

Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved