Home > Workload Solutions > SAP > Guides > SAP HANA TDI Guides > Dell Validated Design for SAP HANA TDI with Dell PowerStore Storage > Configuring SAP HANA NSE
SAP HANA NSE uses the data volume that the main database is using. While no special configuration steps are necessary for the NSE persistence layer, sizing must consider the additional capacity that is required for the feature. When you use SAP HANA NSE, a portion of DRAM is used as a buffer cache to dynamically load paged data from the persistence (data volume). By default, the size of this buffer cache is 10 percent of the total main memory of the system. For more information, see “SAP HANA Buffer Cache” in the SAP HANA Administration Guide.
SAP recommends not exceeding a ratio of 1:8 for the total amount of hot data-warm data that is handled by SAP HANA NSE and the buffer cache. When using SAP HANA NSE, you can store data in the warm tier in the following granularities:
Data location handling is built into the SAP HANA Data Definition Language (DDL). Manage the configuration by using the SAP HANA CLI SQL client hdbsql or the SQL editor in SAP HANA Studio or SAP HANA Cockpit.
CREATE T_DELL_NSE (id INT, name VARCHAR(100)) PAGE LOADABLE;
CREATE T_DELL_NSE (id INT PAGE LOADABLE, name VARCHAR(100));
ALTER TABLE T_DELL_NSE PAGE LOADABLE CASCADE
ALTER TABLET_DELL_NSE ALTER (name VARCHAR(100) PAGE LOADABLE);
Taking real-time statistics from an existing SAP HANA database, SAP HANA NSE Advisor provides recommendations for which data to move from the hot (in-memory) tier to the warm tier (SAP HANA NSE). Use the SAP HANA NSE Advisor information for guidance regarding the amount of data to move to the warm tier on an existing system.
For more information about SAP HANA NSE, SAP HANA NSE Data Sizing, and related topics, see the SAP Help Portal.