What is SAP HANA sizing?

An SAP HANA Sizing is a specific activity that is basically carried out to estimate the hardware requirements for the SAP HANA system that involves major components such as RAM, CPU, and the hard disk. Memory is the primary component in sizing and CPU is the secondary.

What is Hana sizing & tools used for sizing?

Sizing is a term which is used to determine hardware requirement for SAP HANA system, such as RAM, Hard Disk and CPU, etc. The main important sizing component is the Memory, and the second important sizing component is CPU. The third main component is a disk, but sizing is completely dependent on Memory and CPU.

How can we perform sizing for a BW on HANA SAP system?

Depending on the use case, you can use SAP Quick Sizer and/or above SAP notes for sizing Suite/BW on HANA….For greenfield sizing, complete the following steps:

Access the Quick Sizer tool (SAP HANA version)
Create a sizing project – input your customer scenario data into Quick Sizer and it will display the results.

How do you use SAP sizing?

For a greenfield sizing, proceed as follows:

Call Quick Sizer (classic or HANA)
Create a sizing project with the relevant information, such as number of users.
Get an initial result for CPU, disk and memory.
Possibly apply additional guidelines on top.
Check for sample configurations at

How do you run a sizing report in SAP?

Click System > Status then under SAP System Data click the magnifying glass icon:

Once you know you are on the required system version, you can follow the steps to run the report.
In the next window access program /SDF/HDB_SIZING and then click the Execute button (or hit the F8 key):

What is SAP HANA scale out?

Scale out means combining multiple independent computers into one system. The main reason for distributing a system across multiple hosts (that is, scaling out) is to overcome the hardware limitations of a single physical server. This allows an SAP HANA system to distribute the load between multiple servers.

How does DB determine Hana growth?

How to Get the Table Size History in HANA DB

Execute transaction code DB02. Under System Information, double click on Large Tables.
Once the list come out, click on the Table Name and choose Set Filter. Set the filter to table name, USR02.
Change the Max. No.
Now, how do we get the table size history?

What is log volume in SAP HANA?

Data and logs of a system are stored in volumes. SAP HANA persists in-memory data by using savepoints. Each SAP HANA service has its own separate savepoints. During a savepoint operation, the SAP HANA database flushes all changed data from memory to the data volumes.

How do I find the size of my HANA database?

How to find HANA disk size,memory size,record count,memory usage of COLUMN TABLES in HANA

select TABLE_NAME, DISK_SIZE from M_TABLE_PERSISTENCE_STATISTICS where SCHEMA_NAME = ‘SAPSSS’ and TABLE_NAME like ‘/BIC/B%’ order by DISK_SIZE desc.
select * from M_TABLES where TABLE_NAME = ‘CDPOS’ and SCHEMA_NAME=’SAPEDS’;

What is difference between scale up and scale out in HANA?

Scale up means increasing the size of one physical machine by increasing the amount of RAM available for processing. Scale out means combining multiple independent computers into one system. This allows an SAP HANA system to distribute the load between multiple servers.

What is scale out and scale up?

Scaling out is adding more equivalently functional components in parallel to spread out a load. This would be going from two load-balanced web server instances to three instances. Scaling up, in contrast, is making a component larger or faster to handle a greater load.

How do I reduce the size of my DB in HANA?

How to reduce your HANA database size by 30%

Run this script in a QA system before production, for test purposes and so you know how long it will take.
Run it at a quiet time when data loads are not running.
Ensure you have a full backup.
Use this script at your own risk, like any DDL statement it could cause issues.

What is SAP HANA sizing?