SAP HANA Native Storage Extension
This document describes the SAP HANA Native Storage Extension (NSE), which as built-in disk extension of the SAP HANA in-memory database, provides an intelligent technology to process warm data stored on disk. Download the DocumentSAP HANA
Native Storage Extension
__________________________
SAP HANA Development Team
V2.3, October 2025
Native Storage Extension
__________________________
SAP HANA Development Team
V2.3, October 2025
2024 SAP SE or an SAP affiliate company. All rights reserved. See Legal Notice on www.sap.com/legal-notice for use terms, disclaimers, disclosures, or restrictions related to this material. 2/35
Contents
Change History ........................................................................................................................................ 4
Motivation ............................................................................................................................................... 5
About this document........................................................................................................................... 5
The Data Growth Challenge ................................................................................................................ 5
The Data Pyramid and Multi-Temperature Data Management Solution............................................ 5
Introducing SAP HANA Native Storage Extension ................................................................................... 6
Increasing the HANA Database Volume Capacity with NSE ................................................................ 6
NSE Technology Overview ....................................................................................................................... 7
Load Units ............................................................................................................................................ 8
Buffer Cache ........................................................................................................................................ 9
Buffer Cache Elasticity ................................................................................................................... 10
NSE Advisor ....................................................................................................................................... 12
Unified Persistence............................................................................................................................ 12
Plan, Implement, and Monitor NSE ....................................................................................................... 13
Phase 1: Plan NSE .............................................................................................................................. 13
Analyze the Application Data Design ............................................................................................ 13
Analyze the Database Table Statistics ........................................................................................... 14
Enable NSE Advisor........................................................................................................................ 14
NSE Advisor in SAP HANA Cloud .................................................................................................... 21
Phase 2: Implement NSE ................................................................................................................... 21
Table Partitioning .......................................................................................................................... 21
Adjust the Load Unit Properties .................................................................................................... 22
Buffer Cache Configuration ........................................................................................................... 23
Phase 3: Monitor the NSE Usage ....................................................................................................... 25
Monitoring NSE with SAP HANA Cockpit and SAP HANA Cloud Central ....................................... 25
Monitoring NSE with SQL Views .................................................................................................... 27
Data Center Operations with NSE ......................................................................................................... 30
Host Auto-Failover, System Replication and Backup/Recovery ........................................................ 30
Security and Encryption .................................................................................................................... 31
Columns with large object data types (LOB columns) in NSE ........................................................... 31
Persistent Memory (PMEM) and NSE ............................................................................................... 31
Fast Restart Option and NSE ............................................................................................................. 31
Statistic Data and NSE ....................................................................................................................... 31
Contents
Change History ........................................................................................................................................ 4
Motivation ............................................................................................................................................... 5
About this document........................................................................................................................... 5
The Data Growth Challenge ................................................................................................................ 5
The Data Pyramid and Multi-Temperature Data Management Solution............................................ 5
Introducing SAP HANA Native Storage Extension ................................................................................... 6
Increasing the HANA Database Volume Capacity with NSE ................................................................ 6
NSE Technology Overview ....................................................................................................................... 7
Load Units ............................................................................................................................................ 8
Buffer Cache ........................................................................................................................................ 9
Buffer Cache Elasticity ................................................................................................................... 10
NSE Advisor ....................................................................................................................................... 12
Unified Persistence............................................................................................................................ 12
Plan, Implement, and Monitor NSE ....................................................................................................... 13
Phase 1: Plan NSE .............................................................................................................................. 13
Analyze the Application Data Design ............................................................................................ 13
Analyze the Database Table Statistics ........................................................................................... 14
Enable NSE Advisor........................................................................................................................ 14
NSE Advisor in SAP HANA Cloud .................................................................................................... 21
Phase 2: Implement NSE ................................................................................................................... 21
Table Partitioning .......................................................................................................................... 21
Adjust the Load Unit Properties .................................................................................................... 22
Buffer Cache Configuration ........................................................................................................... 23
Phase 3: Monitor the NSE Usage ....................................................................................................... 25
Monitoring NSE with SAP HANA Cockpit and SAP HANA Cloud Central ....................................... 25
Monitoring NSE with SQL Views .................................................................................................... 27
Data Center Operations with NSE ......................................................................................................... 30
Host Auto-Failover, System Replication and Backup/Recovery ........................................................ 30
Security and Encryption .................................................................................................................... 31
Columns with large object data types (LOB columns) in NSE ........................................................... 31
Persistent Memory (PMEM) and NSE ............................................................................................... 31
Fast Restart Option and NSE ............................................................................................................. 31
Statistic Data and NSE ....................................................................................................................... 31