SAP HANA Azure virtual machine Ultra Disk storage configurations

This document is about HANA storage configurations for Azure Ultra Disk storage as it was introduced as ultra low latency storage for DBMS and other applications that need ultra low latency storage. For general considerations around stripe sizes when using LVM, HANA data volume partitioning or other considerations that are independent of the particular storage type, check these two documents:

Azure Ultra disk storage configuration for SAP HANA

Another Azure storage type is called Azure Ultra disk. The significant difference between Azure storage offered so far and Ultra disk is that the disk capabilities aren't bound to the disk size anymore. As a customer you can define these capabilities for Ultra disk:

  • Size of a disk ranging from 4 GiB to 65,536 GiB
  • IOPS range from 100 IOPS to 160K IOPS (maximum depends on VM types as well)
  • Storage throughput from 300 MB/sec to 2,000 MB/sec

Ultra disk gives you the possibility to define a single disk that fulfills your size, IOPS, and disk throughput range. Instead of using logical volume managers like LVM or MDADM on top of Azure premium storage to construct volumes that fulfill IOPS and storage throughput requirements. You can run a configuration mix between Ultra disk and premium storage. As a result, you can limit the usage of Ultra disk to the performance critical /hana/data and /hana/log volumes and cover the other volumes with Azure premium storage

Other advantages of Ultra disk can be the better read latency in comparison to premium storage. The faster read latency can have advantages when you want to reduce the HANA startup times and the subsequent load of the data into memory. Advantages of Ultra disk storage also can be felt when HANA is writing savepoints.

Note

Ultra disk might not be present in all the Azure regions. For detailed information where Ultra disk is available and which VM families are supported, check the article What disk types are available in Azure?.

In this configuration, you keep the /hana/data and /hana/log volumes separately. The suggested values are derived out of the KPIs that SAP has to certify VM types for SAP HANA and storage configurations as recommended in the SAP TDI Storage Whitepaper.

The recommendations are often exceeding the SAP minimum requirements as stated earlier in this article. The listed recommendations are a compromise between the size recommendations by SAP and the maximum storage throughput the different VM types provide.

Note

Azure Ultra disk is enforcing a minimum of 2 IOPS per Gigabyte capacity of a disk

VM SKU RAM Max. VM I/O
Throughput
/hana/data volume /hana/data I/O throughput /hana/data IOPS /hana/log volume /hana/log I/O throughput /hana/log IOPS
E20ds_v4 160 GiB 480 MB/s 200 GB 400 MBps 2,500 80 GB 250 MB 1,800
E32ds_v4 256 GiB 768 MB/s 300 GB 400 MBps 2,500 128 GB 250 MBps 1,800
E48ds_v4 384 GiB 1152 MB/s 460 GB 400 MBps 3,000 192 GB 250 MBps 1,800
E64ds_v4 504 GiB 1200 MB/s 610 GB 400 MBps 3,500 256 GB 250 MBps 1,800
E64s_v3 432 GiB 1,200 MB/s 610 GB 400 MBps 3,500 220 GB 250 MB 1,800
M32ts 192 GiB 500 MB/s 250 GB 400 MBps 2,500 96 GB 250 MBps 1,800
M32ls 256 GiB 500 MB/s 300 GB 400 MBps 2,500 256 GB 250 MBps 1,800
M64ls 512 GiB 1,000 MB/s 620 GB 400 MBps 3,500 256 GB 250 MBps 1,800
M32dms_v2, M32ms_v2 875 GiB 500 MB/s 1,200 GB 600 MBps 5,000 512 GB 250 MBps 2,500
M64s, M64ds_v2, M64s_v2 1,024 GiB 1,000 MB/s 1,200 GB 600 MBps 5,000 512 GB 250 MBps 2,500
M64ms, M64dms_v2, M64ms_v2 1,792 GiB 1,000 MB/s 2,100 GB 600 MBps 5,000 512 GB 250 MBps 2,500
M128s, M128ds_v2, M128s_v2 2,048 GiB 2,000 MB/s 2,400 GB 750 MBps 7,000 512 GB 250 MBps 2,500
M192ids_v2, M192is_v2 2,048 GiB 2,000 MB/s 2,400 GB 750 MBps 7,000 512 GB 250 MBps 2,500
M128ms, M128dms_v2, M128ms_v2 3,892 GiB 2,000 MB/s 4,800 GB 750 MBps 9,600 512 GB 250 MBps 2,500
M192idms_v2, M192ims_v2 4,096 GiB 2,000 MB/s 4,800 GB 750 MBps 9,600 512 GB 250 MBps 2,500
M208s_v2 2,850 GiB 1,000 MB/s 3,500 GB 750 MBps 7,000 512 GB 250 MBps 2,500
M208ms_v2 5,700 GiB 1,000 MB/s 7,200 GB 750 MBps 14,400 512 GB 250 MBps 2,500
M416s_v2 5,700 GiB 2,000 MB/s 7,200 GB 1,000 MBps 14,400 512 GB 400 MBps 4,000
M416ms_v2 11,400 GiB 2,000 MB/s 14,400 GB 1,500 MBps 28,800 512 GB 400 MBps 4,000

The values listed are intended to be a starting point and need to be evaluated against the real demands. The advantage with Azure Ultra disk is that the values for IOPS and throughput can be adapted without the need to shut down the VM or halting the workload applied to the system.

Note

So far, storage snapshots with Ultra disk storage is not available. This blocks the usage of VM snapshots with Azure Backup Services

Next steps

For more information, see: