Storage Configuration for SAP HANA - SAP HANA on AWS

Storage Configuration for SAP HANA

SAP HANA stores and processes all or most of its data in memory, and provides protection against data loss by saving the data in persistent storage locations. To achieve optimal performance, the storage solution used for SAP HANA data and log volumes should meet SAP's storage KPI. AWS has worked with SAP to certify both Amazon EBS General Purpose SSD (gp2) and Provisioned IOPS SSD (io1 and io2) storage solutions for SAP HANA workloads.

gp2 volumes balance price and performance for a variety of workloads, while io1 and io2 volumes provide the highest performance for mission-critical applications. Choose the best storage solution that meets your performance and cost requirements. We recommend the io2 configuration for mission-critical SAP HANA production workloads.

Note that only the following instances are certified for production use: r3.8xlarge, r4.8xlarge, r4.16xlarge, r5.8xlarge, r5.12xlarge, r5.16xlarge, r5.24xlarge, r5.metal, r5b.8xlarge, r5b.12xlarge, r5b.16xlarge, r5b.24xlarge, r5b.metal, x1.16xlarge, x1.32xlarge, x1e.32xlarge, u-6tb1.56xlarge, u-6tb1.112xlarge, u-9tb1.112xlarge, u-12tb1.112xlarge, u-6tb1.metal, u-9tb1.metal, u-12tb1.metal, u-18tb1.metal, and u-24tb1.metal. For nonproduction use, all of the instance types in this Quick Start are supported.

For multinode deployments, storage volumes for SAP HANA data and logs are provisioned in the master node and worker nodes.

In the following configurations, we intentionally kept the same storage configuration for SAP HANA data and log volumes for all R3, certain R4 and R5, and smaller X1e instance types so you can scale up from smaller instances to larger instances without having to reconfigure your storage.

gp2 for HANA data
Instance type Memory (GiB) vCPUs / logical processors* General Purpose SSD (gp2) storage for SAP HANA data (striped with LVM) Total maximum throughput (MiB/s) Total baseline IOPS Total burst IOPS
Certified for production use
u-24tb1.metal 24,576 448 6 x 4,800 GiB 1,500 86,400 N/A
u-18tb1.metal 18,432 448 6 x 3,600 GiB 1,500 64,800 N/A
u-12tb1.112xlarge 12,288 448 6 x 2,400 GiB 1,500 43,200 N/A
u-12tb1.metal 12,288 448 6 x 2,400 GiB 1,500 43,200 N/A
u-9tb1.112xlarge 9,216 448 6 x 1,800 GiB 1,500 32,400 N/A
u-9tb1.metal 9,216 448 6 x 1,800 GiB 1,500 32,400 N/A
u-6tb1.112xlarge 6,144 448 6 x 1,200 GiB 1,500 21,600 N/A
u-6tb1.56xlarge 6,144 224 6 x 1,200 GiB 1,500 21,600 N/A
u-6tb1.metal 6,144 448 6 x 1,200 GiB 1,500 21,600 N/A
x1e.32xlarge 3,904 128 3 x 1,600 GiB 750 14,400 N/A
x1.32xlarge 1,952 128 3 x 800 GiB 750 7,200 9,000
x1.16xlarge 976 64 3 x 400 GiB 750 3,600 9,000
r5.metal 768 96 3 x 400 GiB 750 3,600 9,000
r5b.metal 768 96 3 x 400 GiB 750 3,600 9,000
r5.24xlarge 768 96 3 x 400 GiB 750 3,600 9,000
r5b.24xlarge 768 96 3 x 400 GiB 750 3,600 9,000
r5.16xlarge 512 64 3 x 225 GiB 750 2,025 9,000
r5b.16xlarge 512 64 3 x 225 GiB 750 2,025 9,000
r4.16xlarge 488 64 3 x 225 GiB 750 2,025 9,000
r5.12xlarge 384 48 3 x 225 GiB 750 2,025 9,000
r5b.12xlarge 384 48 3 x 225 GiB 750 2,025 9,000
r5.8xlarge 256 32 3 x 225 GiB 750 2,025 9,000
r5b.8xlarge 256 32 3 x 225 GiB 750 2,025 9,000
r4.8xlarge 244 32 3 x 225 GiB 750 2,025 9,000
r3.8xlarge
Supported for nonproduction use only
x1e.4xlarge 488 16 3 x 225 GiB 750** 2,025 9,000
x1e.2xlarge 244 8 3 x 225 GiB 750** 2,025 9,000
x1e.xlarge 122 4 3 x 225 GiB 750** 2,025 9,000
r5.4xlarge 128 16 3 x 225 GiB 750** 2,025 9,000
r5b.4xlarge 128 16 3 x 225 GiB 750** 2,025 9,000
r5.2xlarge 64 8 3 x 225 GiB 750** 2,025 9,000
r5b.2xlarge 64 8 3 x 225 GiB 750** 2,025 9,000
r4.4xlarge 122 16 3 x 225 GiB 750** 2,025 9,000
r3.4xlarge
r4.2xlarge 61 8 3 x 225 GiB 750** 2,025 9,000
r3.2xlarge

* Each logical processor offered by Amazon EC2 High Memory Instances is a hyperthread on a physical CPU core.

** This value represents the maximum throughput that could be achieved when striping multiple EBS volumes. Actual throughput depends on the instance type. Every instance type has its own Amazon EBS throughput maximum. For details, see Amazon EBS-Optimized Instances in the AWS documentation.

gp2 for HANA logs
Instance type Memory (GiB) vCPUs / logical processors* General Purpose SSD (gp2) storage for SAP HANA logs (striped with LVM) Total maximum throughput (MiB/s) Total baseline IOPS Total burst IOPS
Certified for production use
u-24tb1.metal 24,576 448 2 x 300 GiB 500 1,800 6,000
u-18tb1.metal 18,432 448 2 x 300 GiB 500 1,800 6,000
u-12tb1.112xlarge 12,288 448 2 x 300 GiB 500 1,800 6,000
u-12tb1.metal 12,288 448 2 x 300 GiB 500 1,800 6,000
u-9tb1.112xlarge 9,216 448 2 x 300 GiB 500 1,800 6,000
u-9tb1.metal 9,216 448 2 x 300 GiB 500 1,800 6,000
u-6tb1.112xlarge 6,144 448 2 x 300 GiB 500 1,800 6,000
u-6tb1.56xlarge 6,144 224 2 x 300 GiB 500 1,800 6,000
u-6tb1.metal 6,144 448 2 x 300 GiB 500 1,800 6,000
x1e.32xlarge 3,904 128 2 x 300 GiB 500 1,800 6,000
x1.32xlarge 1,952 128 2 x 300 GiB 500 1,800 6,000
x1.16xlarge 976 64 2 x 300 GiB 500 1,800 6,000
r5.metal 768 96 2 x 300 GiB 500 1,800 6,000
r5b.metal 768 96 2 x 300 GiB 500 1,800 6,000
r5.24xlarge 768 96 2 x 300 GiB 500 1,800 6,000
r5b.24xlarge 768 96 2 x 300 GiB 500 1,800 6,000
r5.16xlarge 512 64 2 x 300 GiB 500 1,800 6,000
r5b.16xlarge 512 64 2 x 300 GiB 500 1,800 6,000
r4.16xlarge 488 64 2 x 300 GiB 500 1,800 6,000
r5.12xlarge 384 48 2 x 300 GiB 500 1,800 6,000
r5b.12xlarge 384 48 2 x 300 GiB 500 1,800 6,000
r5.8xlarge 256 32 2 x 300 GiB 500 1,800 6,000
r5b.8xlarge 256 32 2 x 300 GiB 500 1,800 6,000
r4.8xlarge 244 32 2 x 300 GiB 500 1,800 6,000
r3.8xlarge
Supported for nonproduction use only
x1e.4xlarge 488 16 2 x 175 GiB 500** 1,050 6,000
x1e.2xlarge 244 8 2 x 175 GiB 500** 1,050 6,000
x1e.xlarge 122 4 2 x 175 GiB 500** 1,050 6,000
r5.4xlarge 128 16 2 x 175 GiB 500** 1,050 6,000
r5b.4xlarge 128 16 2 x 175 GiB 500** 1,050 6,000
r5.2xlarge 64 8 2 x 175 GiB 500** 1,050 6,000
r5b.2xlarge 64 8 2 x 175 GiB 500** 1,050 6,000
r4.4xlarge 122 16 2 x 175 GiB 500** 1,050 6,000
r3.4xlarge
r4.2xlarge 61 8 2 x 175 GiB 500** 1,050 6,000
r3.2xlarge

* Each logical processor offered by Amazon EC2 High Memory Instances is a hyperthread on a physical CPU core.

** This value represents the maximum throughput that could be achieved when striping multiple EBS volumes. Actual throughput depends on the instance type. Every instance type has its own Amazon EBS throughput maximum. For details, see Amazon EBS-Optimized Instances in the AWS documentation.

io1/io2 for HANA data
Instance type Memory (GiB) vCPUs / logical processors* Provisioned IOPS SSD (io1/io2) storage for SAP HANA data (striped with LVM) Total maximum throughput (MiB/s) Total provisioned IOPS
Certified for production use
u-24tb1.metal 24,576 448 6 x 4,800 GiB 3,000 18,000
u-18tb1.metal 18,432 448 6 x 3,600 GiB 3,000 18,000
u-12tb1.112xlarge 12,288 448 6 x 2,400 GiB 3,000 12,000
u-12tb1.metal 12,288 448 6 x 2,400 GiB 3,000 12,000
u-9tb1.112xlarge 9,216 448 6 x 1,800 GiB 3,000 12,000
u-9tb1.metal 9,216 448 6 x 1,800 GiB 3,000 12,000
u-6tb1.112xlarge 6,144 448 6 x 1,200 GiB 3,000 12,000
u-6tb1.56xlarge 6,144 224 6 x 1,200 GiB 3,000 12,000
u-6tb1.metal 6,144 448 6 x 1,200 GiB 3,000 12,000
x1e.32xlarge 3,904 128 3 x 1,600 GiB 1,500 9,000
x1.32xlarge 1,952 128 3 x 800 GiB 1,500 9,000
x1.16xlarge 976 64 1 x 1,200 GiB 500 7,500
r5.metal 768 96 1 x 1,200 GiB 500 7,500
r5b.metal 768 96 1 x 1,200 GiB 500 7,500
r5.24xlarge 768 96 1 x 1,200 GiB 500 7,500
r5b.24xlarge 768 96 1 x 1,200 GiB 500 7,500
r5.16xlarge 512 64 1 x 600 GiB 500 7,500
r5b.16xlarge 512 64 1 x 600 GiB 500 7,500
r4.16xlarge 488 64 1 x 600 GiB 500 7,500
r5.12xlarge 384 48 1 x 600 GiB 500 7,500
r5b.12xlarge 384 48 1 x 600 GiB 500 7,500
r5b.8xlarge 256 32 1 x 300 GiB 500 7,500
r5.8xlarge 256 32 1 x 300 GiB 500 7,500
r4.8xlarge 244 32 1 x 300 GiB 500 7,500
r3.8xlarge
Supported for nonproduction use only
x1e.4xlarge 488 16 1 x 600 GiB 500** 2,000
x1e.2xlarge 244 8 1 x 300 GiB 500** 2,000
x1e.xlarge 122 4 1 x 300 GiB 500** 2,000
r5.4xlarge 128 16 1 x 300 GiB 500** 2,000
r5b.4xlarge 128 16 1 x 300 GiB 500** 2,000
r5.2xlarge 64 8 1 x 300 GiB 500** 2,000
r5b.2xlarge 64 8 1 x 300 GiB 500** 2,000
r4.4xlarge 122 16 1 x 300 GiB 500** 2,000
r3.4xlarge
r4.2xlarge 61 8 1 x 300 GiB 500** 2,000
r3.2xlarge

* Each logical processor offered by Amazon EC2 High Memory Instances is a hyperthread on a physical CPU core.

** This value represents the maximum throughput that could be achieved when striping multiple EBS volumes. Actual throughput depends on the instance type. Every instance type has its own Amazon EBS throughput maximum. For details, see Amazon EBS-Optimized Instances in the AWS documentation.

io1/io2 for HANA logs
Instance type Memory (GiB) vCPUs / logical processors* Provisioned IOPS SSD (io1/io2) storage for SAP HANA logs (striped with LVM) Total maximum throughput (MiB/s) Total provisioned IOPS
Certified for production use
u-24tb1.metal 24,576 448 1 x 525 GiB 500 2,000
u-18tb1.metal 18,432 448 1 x 525 GiB 500 2,000
u-12tb1.112xlarge 12,288 448 1 x 525 GiB 500 2,000
u-12tb1.metal 12,288 448 1 x 525 GiB 500 2,000
u-9tb1.metal 9,216 448 1 x 525 GiB 500 2,000
u-9tb1.112xlarge 9,216 448 1 x 525 GiB 500 2,000
u-6tb1.metal 6,144 448 1 x 525 GiB 500 2,000
u-6tb1.112xlarge 6,144 448 1 x 525 GiB 500 2,000
u-6tb1.56xlarge 6,144 224 1 x 525 GiB 500 2,000
x1e.32xlarge 3,904 128 1 x 525 GiB 500 2,000
x1.32xlarge 1,952 128 1 x 525 GiB 500 2,000
x1.16xlarge 976 64 1 x 525 GiB 500 2,000
r5.metal 768 96 1 x 525 GiB 500 2,000
r5b.metal 768 96 1 x 525 GiB 500 2,000
r5.24xlarge 768 96 1 x 525 GiB 500 2,000
r5b.24xlarge 768 96 1 x 525 GiB 500 2,000
r5.16xlarge 512 64 1 x 260 GiB 500 2,000
r5b.16xlarge 512 64 1 x 260 GiB 500 2,000
r4.16xlarge 488 64 1 x 260 GiB 500 2,000
r5.12xlarge 384 48 1 x 260 GiB 500 2,000
r5b.12xlarge 384 48 1 x 260 GiB 500 2,000
r5.8xlarge 256 32 1 x 260 GiB 500 2,000
r5b.8xlarge 256 32 1 x 260 GiB 500 2,000
r4.8xlarge 244 32 1 x 260 GiB 500 2,000
r3.8xlarge
Supported for nonproduction use only
x1e.4xlarge 488 16 1 x 260 GiB 500** 1,000
x1e.2xlarge 244 8 1 x 260 GiB 500** 1,000
x1e.xlarge 122 4 1 x 260 GiB 500** 1,000
r5.4xlarge 128 16 1 x 260 GiB 500** 1,000
r5b.4xlarge 128 16 1 x 260 GiB 500** 1,000
r5.2xlarge 64 8 1 x 260 GiB 500** 1,000
r5b.2xlarge 64 8 1 x 260 GiB 500** 1,000
r4.4xlarge 122 16 1 x 260 GiB 500** 1,000
r3.4xlarge
r4.2xlarge 61 8 1 x 260 GiB 500** 1,000
r3.2xlarge

* Each logical processor offered by Amazon EC2 High Memory Instances is a hyperthread on a physical CPU core.

** This value represents the maximum achievable throughput when striping multiple EBS volumes. Actual throughput depends on the instance type. Every instance type has its own Amazon EBS throughput maximum. For more information, see Amazon EBS-Optimized Instances.

In addition to the SAP HANA data and log volumes, all instances deployed by this Quick Start have the following storage configuration for root, SAP binaries, and SAP HANA shared and backup volumes:

Instance type Memory (GiB) vCPUs / logical processors* Root volume (gp2) SAP binaries (gp2) SAP HANA shared** (gp2) SAP HANA backup*** (st1)
Certified for production use
u-24tb1.metal 24,576 448 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 2 x 16,384 GiB
u-18tb1.metal 18,432 448 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 2 x 16,384 GiB
u-12tb1.112xlarge 12,288 448 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 16,384 GiB
u-12tb1.metal 12,288 448 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 16,384 GiB
u-9tb1.112xlarge 9,216 448 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 16,384 GiB
u-9tb1.metal 9,216 448 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 16,384 GiB
u-6tb1.metal 6,144 448 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 12,288 GiB
u-6tb1.112xlarge 6,144 448 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 12,288 GiB
u-6tb1.56xlarge 6,144 224 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 12,288 GiB
x1e.32xlarge 3,904 128 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 8,192 GiB
x1.32xlarge 1,952 128 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 4,096 GiB
x1.16xlarge 976 64 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 2,048 GiB
r5.metal 768 96 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 2,048 GiB
r5b.metal 768 96 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 2,048 GiB
r5.24xlarge 768 96 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 2,048 GiB
r5b.24xlarge 768 96 1 x 50 GiB 1 x 50 GiB 1 x 1,024 GiB 1 x 2,048 GiB
r5.16xlarge 512 64 1 x 50 GiB 1 x 50 GiB 1 x 512 GiB 1 x 1,024 GiB
r5b.16xlarge 512 64 1 x 50 GiB 1 x 50 GiB 1 x 512 GiB 1 x 1,024 GiB
r4.16xlarge 488 64 1 x 50 GiB 1 x 50 GiB 1 x 512 GiB 1 x 1,024 GiB
r5.12xlarge 384 48 1 x 50 GiB 1 x 50 GiB 1 x 512 GiB 1 x 1,024 GiB
r5b.12xlarge 384 48 1 x 50 GiB 1 x 50 GiB 1 x 512 GiB 1 x 1,024 GiB
r5.8xlarge 256 32 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 1,024 GiB
r5b.8xlarge 256 32 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 1,024 GiB
r4.8xlarge 244 32 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 1,024 GiB
r3.8xlarge
Supported for nonproduction use only
x1e.4xlarge 488 16 1 x 50 GiB 1 x 50 GiB 1 x 512 GiB 1 x 1,024 GiB
x1e.2xlarge 244 8 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 512 GiB
x1e.xlarge 122 4 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 512 GiB
r5.4xlarge 128 16 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 512 GiB
r5b.4xlarge 128 16 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 512 GiB
r5.2xlarge 64 8 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 512 GiB
r5b.2xlarge 64 8 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 512 GiB
r4.4xlarge 122 16 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 512 GiB
r3.4xlarge
r4.2xlarge 61 8 1 x 50 GiB 1 x 50 GiB 1 x 300 GiB 1 x 512 GiB
r3.2xlarge

* Each logical processor offered by Amazon EC2 High Memory Instances is a hyperthread on a physical CPU core.

** In a multinode architecture, the SAP HANA NFS shared volume is provisioned only once on the master node.

*** In a multinode architecture, the SAP HANA backup volume can be deployed as NFS or Amazon EFS. The size of the SAP HANA NFS backup volume is multiplied by the number of nodes. The SAP HANA backup volume is provisioned only once on the master node, and NFS is mounted on the worker nodes. There is no provision needed for Amazon EFS as it is built to scale on demand, growing and shrinking automatically as files are added and removed.

Note

General Purpose SSD (gp2) volumes created or modified after 12/03/2018 have a throughput maximum between 128 MiB/s and 250 MiB/s depending on volume size. Volumes greater than 170 GiB and below 334 GiB deliver a maximum throughput of 250 MiB/s if burst credits are available. Volumes with 334 GiB and above deliver 250 MiB/s, irrespective of burst credits. For details, see Amazon EBS Volume Types in the AWS documentation.

For single-node deployment, storage for SAP HANA backup is configured with Amazon EBS Throughput Optimized HDD (st1) volumes. This volume type provides low-cost magnetic storage designed for large sequential workloads. SAP HANA uses sequential I/O with large blocks to back up the database, so st1 volumes provide a low-cost, high-performance option for this scenario. To learn more about st1 volumes, see Amazon EBS Volume Types in the AWS documentation.

The SAP HANA backup volume size is designed to provide optimal baseline and burst throughput as well as the ability to hold several backup sets. Holding multiple backup sets in the backup volume makes it easier to recover your database if necessary. You may resize your SAP HANA backup volume after initial setup if needed. To learn more about resizing your Amazon EBS volumes, see Expanding the Storage Size of an EBS Volume on Linux in the AWS documentation.

For multi-node deployment, SAP HANA backup deployed with Amazon EFS can support performance over 10 GB/sec and over 500,000 IOPS.