Home > Workload Solutions > SAP > Guides > SAP HANA TDI Guides > Dell Validated Design for SAP HANA TDI with Dell PowerMax 2500 and 8500 Storage Arrays > SAP HANA database
The SAP HANA in-memory database is at the core of the SAP HANA data platform. The data is kept in the RAM of one or more SAP HANA worker hosts and all database operations (reads, inserts, updates, and deletions) are performed in the main memory of the host. In traditional databases, only a part of the data is cached in RAM and the remaining data resides on disk.
Persistent storage enables you to restore the SAP HANA database to its most recent committed state in a failure scenario. The log captures all changes by database transactions (redo logs), and data and undo log information is automatically saved to disk at regular savepoints.
PowerMax arrays can be used for both single-host (scale-up) and multihost (scale-out) systems in TDI deployments.
In single-host environments, the database must fit into the RAM of a single server. Single-host environments are preferred for online transaction processing (OLTP)-type workloads such as S/4HANA and SAP Business Suite on SAP HANA.
In multihost environments, the database tables are distributed across the RAM of multiple servers. These environments use worker and standby hosts. A worker host is an active component that accepts and processes database requests, while a standby host is a passive component that has all database services running but no data in RAM. A standby host waits for a failure of a worker host so that it can take over its role, a process known as host autofailover. Because the in-memory capacity in these deployments can be high, scale-out SAP HANA clusters are ideally suited for online analytical processing (OLAP)-type workloads with large datasets, such as SAP Business Warehouse on SAP HANA and BW/4HANA. By default, SAP supports scale-out deployments of up to 16 worker hosts. If more than 16 worker hosts are needed, SAP requires a site-specific certification.