SAP HANA and Persistent Memory Introduction and SAP HANA Hardware Sizing for Persistent Memory | SAP HANA fast restart option
In this Article, I am going to explain following points for SAP HANA and Persistent memory
- Persistent memory introduction
- Advantage of Persistent Memory in SAP HANA infrastructure
- Comparison of DRAM vs ( DRAM + PMEM ) infrastructure
- SAP HANA Fast restart option and comparison with SAP HANA Persistent Memory
- SAP HANA Hardware sizing with persistent memory – Greenfield and Brownfield
Introduction of Persistent memory.
SAP HANA is an in-memory-first database. This means SAP HANA performs all database operations directly on the in-memory data structures.
Persistent memory is new type of memory with following main features. Persistent memory is supported with SAP HANA 2.00.035 and higher.
Persistent memory (non-volatile RAM, NVRAM, virtual persistent memory, vPMEM, also referred to as storage class memory) is an additional persistent storage type that combines fast accesses (like memory) with durable storage (like disk) that isn’t lost in case of crashes or restarts.
Below diagram explains different SAP HANA areas when moving from DRAM to DRAM+ PMEM (mixed) hardware infrastructure. SAP HANA controls what is placed in Persistent Memory and what remains in DRAM
Let’s understand both the options from below tables comparison.
|Option- A ( DRAM )||Option- B ( DRAM + PMEM)|
|DRAM hardware contains: SAP HANA work area + Column Store Tables + Row Store Tables||PMEM contains Column Store tables while DRAM contains others segments as per above diagram|
|When the infrastructure includes only DRAM infrastructure, the initial table load occurs each time the database is started after planned or unplanned outages||When the infrastructure includes persistent memory, the initial table load is no longer necessary. Data stored in persistent memory is retained across planned outage events and unplanned events, such as natural disasters.|
|In case of any power outage and unplanned events we can consider approx. 30-40 min additional time (based upon customer experience) for column store tables load in the SAP memory for large SAP HANA database||No additional time for column store tables in case of any power outage and unplanned events.|
Comparison between Intel® Optane™ DC Persistent Memory and Other Memory Types:
|Memory Type||Tier||Memory Technology||Non-Volatile||Capacity||TCO||Restart time including data reloading|
|Intel® Optane™ DC Persistent Memory||Hot||3D Xpoint||Yes||High||Medium||Fast|
|HDD||Cold||Spinning disk-based||Yes||High||Very low||NA|
Intel® Optane™ DC Persistent Memory is featured with:
- High capacity: up to 512GB per memory slot (4x greater than traditional 128 GB DDR4 DIMM sizes), letting enterprises keep more data in the hot tier without complex deployment (scale out with multiple SAP HANA nodes, data tiering strategies, etc.)
- Low TCO: lower costs for simplified infrastructure (update servers to support PMEM and scale-up instead of scale-out) and simplified data-tiering management (more data in hot and warm tiers)
- Good access speed: near-DDR4 DRAM performance (similar read performance but slower write performance) in the same dual in-line memory module (DIMM) slot as DRAM.
- Fast restart time: byte-addressable like DDR4 DRAM, but providing the same persistence as flash- and disk-based block storage that data is retained across server reboots and power outages.
As we are taking about SAP HANA persistent memory, so it is really important to mention few lines about SAP HANA fast restart option.
- With SAP HANA SPS 2.00.040, SAP HANA has great feature : SAP HANA Fast restart option
- Customers on DRAM infrastructure with SAP HANA 2.0 SPS 04 onwards, can go with SAP HANA Fast restart option:
- The SAP HANA Fast Restart option uses storage in the file system to preserve and reuse MAIN data fragments to speed up SAP HANA restarts. This is effective in cases where the operating system is not restarted.
The fast restart option works in a similar way like persistent memory with the difference that the main storages are lost when the server is crashed or rebooted, however in case of SAP HANA restart column tables load will not happen with each restart .A quick comparison will help you to understand both options
|Area||Persistent Memory||Fast Restart Option|
|SAP HANA Revision level||>= 2.00.035||>= 2.00.040|
|Limited by||persistent_memory_global_allocation_limit||global_allocation_limit (>= 2.00.050)|
|Memory kept across SAP HANA restarts||yes||yes|
|Memory kept across OS restarts||yes||no|
|Infrastructure requirements||limited (SAP Note 2618154)||generally available|
Now let’s understand SAP HANA Hardware sizing with Persistent memory :
SAP HANA Hardware Sizing with Persistent Memory:
SAP HANA with persistent memory follows the same sizing rules as SAP HANA with only DRAM
- SAP HANA quicksizer: https://apps.support.sap.com/sap/bc/bsp/sap/qs_oberflaeche/hana.do?sap-language=en&bsp-language=en
- Sizing report for SoH and S/4HANA: SAP Note 1872170
- Sizing report for BWoH and BW/4HANA: SAP Note 2296290
- SAP HANA: Sizing SAP In-Memory Database: SAP Note 1514966
- 2786237– Sizing SAP HANA with Persistent Memory
- Recommendations for Persistent Memory Configuration with BW/4HANA: SAP Note 2813454
For Greenfield Sizing ( using quick sizer ) :
Greenfield sizing with Quick Sizer has a separate part for Persisted DB Memory
In the example, 237 GB can be placed in PMEM.
For Brownfield Sizing:
SAP HANA sizing report as of version 77 has an additional section on persistent memory
Sizing report provides NVRAM/PMEM and DRAM memory requirement.
In the example, 4844 GB can be placed in PMEM and 5374 GB in DRAM.
Kindly keep in mind while doing Persistent Memory sizing: (Refer SAP Note 2786237– Sizing SAP HANA with Persistent Memory )
- Ratio between DRAM and PMEM capacity of 2:1, 1:1, 1:2 or 1:4.
- Larger ratios only in exceptional cases (data tiering, where large amounts of warm data will be stored in PMEM).
- Total capacity of up to 24 TB per physical server.
- There should be sufficient hardware resources for the intended use case: Especially DRAM, persistent memory, and CPU.
You can refer following note and articles on Persistent memory topic for more details.
- 2700084 – FAQ: SAP HANA Persistent Memory
- SAP HANA Fast Restart Option
Hope this article will help you to understand important points for Persistent Memory and SAP HANA Hardware sizing for Persistent memory for Greenfield and Brownfield implementation ,SAP HANA fast restart option comparison with Persistent memory.
Kindly share feedback or thoughts in a comment or ask questions if any.