# SAP HANA Memory Sizing Calculator

> Source: https://netray.co/tools/sap-hana-memory-sizing-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

First-pass SAP HANA memory and disk estimate from source database size, compression ratio, growth and work space, with a growth-by-year chart.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- SAP Basis administrator
- SAP infrastructure architect

## Tool

**Kind:** calculator

**Inputs:**

#### Source database size (used data)

**Key:** source_gb

**Type:** number

**Default:** 2000

**Min:** 0

**Step:** 50

**Unit:** GB

**Help:** Used data size on the current anyDB or HANA system, not allocated disk.

#### Expected compression ratio

**Key:** compression

**Type:** select

**Default:** 4

**Options:**

##### 3 to 1

**Value:** 3

##### 4 to 1

**Value:** 4

##### 5 to 1

**Value:** 5

##### 7 to 1

**Value:** 7

**Help:** Typical anyDB to HANA column store ratios fall in this range. Use the SAP sizing report result when you have it.

#### Annual data growth

**Key:** growth_pct

**Type:** number

**Default:** 15

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %/year

#### Planning horizon

**Key:** years

**Type:** slider

**Default:** 3

**Min:** 0

**Max:** 10

**Step:** 1

**Unit:** years

#### Work space factor

**Key:** workspace

**Type:** select

**Default:** 1

**Options:**

##### 0.5 x static data

**Value:** 0.5

##### 1.0 x static data

**Value:** 1

##### 1.5 x static data

**Value:** 1.5

**Help:** Dynamic memory for queries, joins and delta merges, expressed as a multiple of static data memory.

#### Code, stack and OS overhead

**Key:** overhead_gb

**Type:** number

**Default:** 64

**Min:** 0

**Step:** 8

**Unit:** GB

**Outputs:**

#### Static data memory today

**Key:** static_now

**Expr:** source_gb / compression

**Format:** number

**Description:** Compressed in-memory footprint of the data you have today (GB).

#### Static data memory at horizon

**Key:** static_future

**Expr:** static_now * pow(1 + growth_pct / 100, years)

**Format:** number

**Description:** Static memory after compound growth (GB).

#### Recommended RAM

**Key:** ram

**Expr:** static_future * (1 + workspace) + overhead_gb

**Format:** number

**Primary:** true

**Description:** Static data plus work space plus overhead (GB).

#### Data volume (disk)

**Key:** data_vol

**Expr:** ram * 1.2

**Format:** number

**Description:** Common rule of thumb: data volume about 1.2 x RAM (GB).

#### Log volume (disk)

**Key:** log_vol

**Expr:** min(ram * 0.5, 512)

**Format:** number

**Description:** Rule of thumb: 0.5 x RAM, capped at 512 GB.

#### RAM in TB

**Key:** ram_tb

**Expr:** ram / 1024

**Format:** decimal

**Primary:** true

**Chart:**

#### Recommended RAM (GB) vs planning horizon

**Type:** line

**X:** years

**From:** 0

**To:** 10

**Steps:** 11

**Series:**

- ram

**Disclaimer:** Rough planning estimate only. Final sizing must come from SAP Quick Sizer, the SAP sizing reports (for example the HANA memory sizing report for your source system) and your hardware vendor's certified appliance or TDI configurations.

## Content

**Intro:** Before you request hardware or a cloud instance for SAP HANA you need a defensible first number. This calculator turns used database size, compression, growth and work space into a RAM, data volume and log volume estimate you can take into a sizing conversation.

**Sections:**

#### How to use the calculator

**Body:** Enter the used data size of the source database, not the allocated disk. Pick a compression ratio that matches your data profile, set annual growth and a planning horizon, then choose a work space factor. The result shows today's static memory, the static memory after growth, and the recommended RAM. The chart sweeps the planning horizon so you can see how many years a given appliance size will last before you must scale up.

**Bullets:**

- Use used data, not allocated tablespace or file system size
- Take compression from the SAP sizing report if you have run it
- Keep growth realistic, 10 to 20 percent is common for transactional systems
- Compare the RAM result against certified node sizes, not raw GB

#### The method behind the numbers

**Body:** HANA stores most data in compressed column format in memory, so static data memory is roughly source size divided by compression. HANA also needs dynamic memory for intermediate results, so total RAM is static data multiplied by one plus the work space factor, plus a fixed allowance for code, stacks and the operating system. For persistence, SAP guidance for the data volume is about 1.2 times RAM, and for the log volume about half of RAM up to a cap of 512 GB. These are planning rules, not guarantees.

#### Worked example

**Body:** A 2,000 GB source with 4 to 1 compression gives 500 GB of static memory today. At 15 percent growth over 3 years that becomes about 760 GB. With a work space factor of 1.0 and 64 GB of overhead, recommended RAM is about 1,584 GB, so you would look at a 2 TB node. Data volume would be roughly 1.9 TB and log volume 512 GB. Change the factor to 0.5 and the same system fits a 1.5 TB class node, which shows how sensitive the answer is to that one assumption.

#### Common mistakes

**Body:** The biggest error is sizing from allocated disk, which can be double the used data. The second is assuming the same compression for every table: large cluster or pool tables, LOB data and already compressed attachments behave differently. Finally, many teams forget that a migration to S/4HANA changes the data model, so the old database size is only an input to the official sizing, not a substitute for it. Treat this tool as the quick estimate before the formal exercise.

**Cta:** If you want sizing inputs pulled straight from your SAP system tables with a read-only, on-prem assistant that shows its queries, Netray can help set that up.

**Faq:**

#### Is this the official SAP HANA sizing?

**Answer:** No. It is a quick planning estimate. Official sizing comes from SAP Quick Sizer, SAP sizing reports run on your source system, and your hardware or cloud provider's certified configurations. Use this tool to sanity check those results and to build a budget range early.

#### What compression ratio should I use?

**Answer:** Many transactional systems land between 3 to 1 and 5 to 1 when moving from a traditional database, but results vary with data type. Run the SAP sizing report on the source system for a real number and use the closest option here.

#### Why is log volume capped at 512 GB?

**Answer:** The common SAP guidance sets the log volume at half of RAM for smaller systems and a fixed 512 GB for larger ones, since log usage depends on write throughput and not on total memory. Confirm against the current SAP note for your release.

#### Does this cover BW/4HANA or data warehouse workloads?

**Answer:** It is better suited to transactional suite workloads. Warehouse systems have different warm and cold data patterns, different work space needs and often use extension nodes, so use the dedicated SAP sizing guidance for them.

## Search terms

sap hana memory sizing calculator, hana sizing calculator, sap hana ram calculation, hana database size estimate, sap hana disk sizing, s/4hana sizing rough estimate, hana data volume log volume size, sap hana memory growth

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json