Monday, September 30, 2019

SAP 2

SAP HANA Sizing


SAP HANA Pre OS Installation Sizing:

Sizing for this categories is needed:
  1. memory for static data
  2. memory for objects created during runtime
  3. disk sizing
  4. CPU sizing

RAM
SDF (Source Data Footprint) is current Oracle DB size without indexes and blobs (for Oracle use dba_segments).
RAM size = SDF * 2 / 7 (i.e. RAM Size = 300 * 2 / 7 = 85GB but HANA minimum recomendation is 128GB of RAM)

Describing formula:
  1. Both static (in-memory store) and dynamic (executing queries and loading data) RAM data sizes are sized. "2"  comes from RAM dynamic = RAM static.
  2. "7" comes from average compression factor database table size : HANA memory = 7 : 1

HDD

Backup storage >= /hana/data + /hana/log
  • OS = 50GB 
  • /hana/data  = 1 * SDF (i.e. Disk data = 1 * 300 = 300GB)
  • /hana/shared min 1*RAM and up to 1TB = 85GB
  • /hana/log (1/2 * 85 = 42.5GB):
    • if RAM Size <= 512GB = 1/2 * RAM
    • if RAM Size > 512GB = 512GB
  • /usr/sap = 50gb
  • Total HDD = 50 + 300 + 85 + 42.5 + 50 = 527.5GB
CPU

Approximation:
0.0625 core/vCPU is needed per 1GB of RAM

core/vCPU =0.0625 * 128 = 8

Sizing summary
SDF = 300GB
RAM = 128GB
HDD = 527.5GB
core/vCPU = 8

No comments:

Post a Comment