SAP HANA (Formerly Known as FAQ 1619)

Sizing Guidelines

Explore this Page

Overview

This guide provides SAP HANA storage sizing guidelines for DataCore SANsymphony-managed storage hardware. DataCore SANsymphony can be installed in front of any SAP HANA certified storage device using Fibre Channel (FC) connections and serve highly available storage to SAP HANA certified compute nodes.

Fundamental SAP HANA administration skills and understanding of SAP-specific terminology are assumed as well as DataCore SANsymphony terminology and configuration.

Change Summary

Refer to DataCore FAQ 838 for the latest version of the FAQ.

Changes since April 2025

Section(s) Content Changes
Certified Configuration SettingsServer Ports

Updated to specify “FC SCSI only.” Added iSCSI and NVMe/oF ports are not certified.

The SAP HANA Host - Server Ports

Updated to specify “FC SCSI only.” Added iSCSI and NVMe/oF ports are not certified.

Refer to Previous Changes for a list of earlier updates to this FAQ.

Certified Configuration Settings

The Storage Array

This is the storage connected to the DataCore Server that will be used for DataCore SANsymphony disk pools managing SAP HANA virtual disk (vDisk) storage sources. The storage must use Fibre Channel (FC) connectivity and meet SAP HANA certified storage requirements. Refer to the SAP HANA Hardware Directory for details.

The DataCore Server

Server Hardware

The DataCore Server must be a physical machine. DataCore SANsymphony instances running in virtual machines (VM) are not supported for SAP HANA deployments. For a complete list of SAP-certified vendors providing server hardware that can be used for DataCore Servers, visit the official SAP website.

Operating System

Only Windows ‘Standard’ or ‘Datacenter’ editions are supported. Other Windows editions (‘Essential’ or ‘Storage Server’) are not supported for SAP HANA. For more information, refer to the Prerequisites section.

DataCore recommends the use of ‘vanilla’ Windows operating system deployments although a server hardware vendor’s own ‘OEM’ installation is allowed only if it is either a ‘Standard’ or ‘Datacenter’ edition.

DataCore SANsymphony Software

DataCoreDataCore SANsymphony 10.0 PSP12 or later.

Server Ports (FC SCSI Only)

FC SCSI only. iSCSI and NVMe/oF ports are not certified. Any front-end (FE) and mirror (MR) ports used by SAP HANA hosts for their vDisks must not be used by any other hosts that are not running SAP HANA. This also includes not using any back-end (BE) ports used to connect to storage of DataCore SANsymphony disk pools that are used for the SAP HANA host’s storage sources.

Disk Pools

Disk pools used for any type of storage source used by SAP HANA hosts must not be used by any other host. This includes storage sources for vDisks, logstores, mapstores or history logs. Disk pool encryption is supported although the performance of encrypted vDisks will be slightly lower than unencrypted it will still be in the range of SAP HANA’s performance requirements. The disk pool ‘Capacity Optimization’ feature is not supported.

Virtual Disks

Dedicated DataCore Servers are not a requirement if SAP HANA vDisks have their designated disk pool(s) for all their vDisk’s storage sources and their dedicated server ports for all mappings (see Server Ports (FC SCSI Only) section). vDisk encryption is supported (see Disk Pools section).

The SAP HANA Host

Operating System and HANA Version

SUSE Linux and HANA versions must match those listed in SAP note 2235581 - SAP HANA: Supported Operating Systems.

Server Ports (FC SCSI Only)

FC SCSI only. ISCSI and NVMe/oF ports are not certified.

SCSI Disk Timeout

This should be set to 80 seconds for all SCSI devices created from SANsymphony virtual disks. The timeout for a given SCSI device can be checked using the ‘cat’ command.

Example:

cat /sys/block/sda/device/timeout

There are two methods that can be used to change the SCSI disk timeout for a given device.

  • Use the ‘echo’ command – this is temporary and will not survive the next reboot of the Linux host server.
  • Create a custom ‘udev rule’ – this is permanent but will require a reboot for the setting to take effect.

Using the ‘echo’ Command (will not survive a reboot)

Set the SCSI Disk timeout value to 80 seconds:

Copy
Command
echo 80 > /sys/block/[disk_device]/device/timeout

Creating a custom ‘udev’ Rule (permanent but requires a reboot)

Create a file called ‘/etc/udev/rules.d/99-datacore.rules’ with the following settings:

Copy
Command
SUBSYSTEM=="block", ACTION=="add", ATTRS{vendor}=="DataCore", ATTRS{model}=="Virtual Disk ", RUN+="/bin/sh -c 'echo 80 > /sys/block/%k/device/timeout'"

Refer to the KB article for more information.

  • This KB article applies to all current versions of DataCore SANsymphony 10.x as well.
  • Make sure that the udev rule is exactly as written above. Else this may result in the Linux operating system defaulting back to 30 seconds.

  • There are four blank whitespace characters after the ATTRS{model} string which much be observed otherwise paths to SANsymphony virtual disks may not be re-discovered.

ALUA Settings

Hosts must be configured for ALUA. hosts without ALUA configured are not certified. Refer to Registering Hosts for more information.

Multipath Configuration

The 'defaults' section

Add or modify the polling_interval to a value of 60 (seconds).

Copy
Command
defaults { polling_interval 60 }

This tells the host how often to check for access on a previously failed virtual disk path. A smaller setting will interfere with host performance. Do not add this parameter to the 'device' section of the multipath configuration file (see below) as it will prevent the polling from working as expected.

The 'device' section

All the following entries listed are DataCore-required values. See the notes section for more specific technical details.

Copy
Script
device {
    vendor                  "DataCore"
    product                 "Virtual Disk"
    path_checker            tur
    prio                    alua
    hardware_handler        "1 alua"
    failback                10
    rr_weight               priorities
    no_path_retry           fail
    dev_loss_tmo            60
    fast_io_fail_tmo        5
    rr_min_io_rq            100
    path_grouping_policy    group_by_prio
}
  • No other settings and/or values should be used.
  • device section must be encapsulated by a devices section.
  • vendor / product: This is the Vital Product Information presented from SANsymphony for all virtual disks. Refer to the SCSI Standard Inquiry section from the online help.
  • hardware_handler: This value is required to make sure ALUA always behaves as expected.
  • failback(seconds): Adds an additional ‘wait’ period after DataCore SANsymphony has switched the ‘Host Access’ virtual disk state to 'Allowed’ to prevent flip-flopping failback attempts.

Additional Host Settings

Mount Points

Mount Point File System
/hana/log Use XFS
/hana/data Use XFS
/hana/shared Use OCFS2 - for single node HANA deployments without shared storage, use XFS

Mount Point Settings for HANA 2.0

No additional settings are required. Those previously required for HANA 1.0 (see below) are now the default for HANA 2.0.

Mount Point Settings for HANA 1.0

Mount Point Setting
/hana/data /hana/shared async_write_submit_active = on
async_write_submit_blocks = all

An example showing the /hana/data mount point:

Copy
Command
su <SID>adm
cd /usr/sap/<SID>/HDB<Instance> source hdbenv.sh
hdbparam --paramset "fileio[DATA].async_write_submit_active=on" hdbparam --paramset "fileio[DATA].async_write_submit_blocks=all" exit

The global.ini Setting for SCSI Reservations

Add the following line to the ‘storage’ section:

Copy
Command
partition_*_* prtype = 5

Example:

Copy
Command
[communication]
listeninterface = .global

[persistence]
basepath_datavolumes = /hana/data/DB1
basepath_logvolumes  = /hana/log/DB1

[storage]
ha_provider          = hdb_ha.fcClient

partition_*_* prtype = 5

partition_1_data wwid = 360030d907e291103a3c283134157aaa9
partition_1_log  wwid = 360030d90538713038ae1199202243cd1

partition_2_data wwid = 360030d9096461203895975bb29a0891c
partition_2_log  wwid = 360030d90032e1403ee45492f24105626

[trace]
ha_fcclient = info

In the example above, the mount points are identified by their WWID but identifying mount points by an alias is also supported.

A Three HANA Node Setup

Diagram of a three-node HANA setup showing two active nodes and one standby node.In this example, two of the HANA nodes are active, and the third node is standby.

Active Server – host1

Mount Point Description
/hana/log/DB1/mnt00001 <- Mounts host1 Log_vDisk
/hana/data/DB1/mnt00001 <- Mounts host1 Data_vDisk
/hana/log/DB1/mnt00002 <- Mounts host2 Log_vDisk
/hana/data/DB1/mnt00002 <- Mounts host2 Data_vDisk
/hana/shared <- Mounts shared OCFS2 filesystem vDisk

Active Server – host

Mount Point Description
/hana/log/DB1/mnt00001 <- Mounts host1 Log_vDisk
/hana/data/DB1/mnt00001 <- Mounts host1 Data_vDisk
/hana/log/DB1/mnt00002 <- Mounts host2 Log_vDisk
/hana/data/DB1/mnt00002 <- Mounts host2 Data_vDisk
/hana/shared <- Mounts shared OCFS2 filesystem vDisk

Active Server – host3 (in failover host role)

Mount Point Description
/hana/log/DB1/mnt00001 <- Mounts host1 Log_vDisk
/hana/data/DB1/mnt00001 <- Mounts host1 Data_vDisk
/hana/log/DB1/mnt00002 <- Mounts host2 Log_vDisk
/hana/data/DB1/mnt00002 <- Mounts host2 Data_vDisk
/hana/shared <- Mounts shared OCFS2 filesystem vDisk

  • Lines highlighted in blue are mounted when the database is started.

  • Lines not highlighted are available (to that specific host) but are not mounted.
  • In a ‘failover event’ the HANA application will determine which of the other hosts will mount and use the ‘failed host’s’ file systems.
  • As any host at any time may require access to another other hosts’ file systems, all SANsymphony virtual disks used for ‘data’ or ‘log’ file systems must be served to all SAP HANA hosts all the time.

Sizing Recommendations

In a highly-available configuration, when DataCore virtual disks (vDisks) are mirrored between a pair of DataCore Servers, I/O load will be shared between the pair. This means that when one of the DataCore Servers is unavailable – for any reason – the remaining DataCore Server must be able to manage the entire load from all active HANA Nodes.

The minimum configuration for a pair of DataCore Servers, with 8 Gbit/s Fibre Channel (FC) connections, is up to 4 ‘active’ HANA nodes with any number of ‘standby’ nodes. The same configuration using 16 or 32 Gbit/s FC connections can manage up to 8 active HANA nodes with any number of standby nodes.

There is no limit to the amount of HANA nodes that can be served virtual disks by DataCore SANsymphony, but only a maximum of 768 HANA nodes can be ‘active’ at any time.

HANA nodes that are not ‘active’ (i.e., they are in a ‘standby’ role) technically will still have access to any virtual disk served to it but will only be considered as ‘active’ if another active node fails and the HANA application changes the role of the standby node to an active one.

Fibre Channel Ports

The number of FC ports in the DataCore Server will affect the sizing calculation. A DataCore Server must have at least one of each of the following dedicated port roles.

  • Front-end (FE) – the port the HANA nodes connect to as a SCSI Target Mode connection.
  • Back-end (BE) – the port the HANA certified storage connects to as a SCSI Initiator.
  • Mode connection.
  • Mirror (MR) - the port(s) each pair of DataCore Servers connects to between themselves for mirroring the HANA data as both SCSI Initiator and Target connections.
  • No port can be assigned to more than one role.

  • The number of each type of port must be the same for all roles – e.g., 2 FE + 2 BE + 2 MR Ports. Where there are odd numbers of ports use the smallest number possible – e.g., with 7 fibre channel ports use 2 FE + 2 BE + 2 MR port with 1 port unused.
  • DataCore SANsymphony System Managed Mirroring (SMM) is recommended to achieve full load distribution across all MR Ports when there are more than 2 MR Ports existing per DataCore Server.

CPU Cores and Sockets

There needs to be enough CPU sockets to support the PCIe bus lanes of all fibre channel adaptors in the DataCore server. A minimum of two sockets are suggested.

While dual-ported adaptors will reduce the number of PCIe buses needed, DataCore do not recommend using quad-port adaptors as the PCIe slot bandwidth requirements for these devices are usually oversubscribed which will affect performance.

Each FC port should, ideally, have a CPU core available for it to scale the I/O in parallel. Hyper-threaded, virtual cores are recommended only if they are Intel Skylake or AMD Epyc CPU’s (or later).

With two socket systems, this will allow a scaling-up of the DataCore Servers to six FE ports, each using 16 Gbit/s connections, allowing up to 24 active SAP HANA nodes per pair of highly available DataCore Servers.

Memory Cache

Allow at least 200 MB of system RAM for each vDisk presented to a HANA node.

Key Performance Indicator Requirements

The following Key Performance Indicators (KPI) need to be met:

Fibre Channel Connection Matrices

16 Gbit/s or Faster Connections

The following table shows what the minimum DataCore SANsymphony components are required for a specific number of active HANA nodes when using 16 Gbit/s (or faster) Fibre Channel (FC) connections.

 

Active nodes

 

Front-end Ports

Mirror Ports

 

Back-end Ports

 

DataCore Server CPU Cores

 

Number of Virtual Disks

DataCore SANsymphony Cache Usage (MB)

1

1

1

1

7

4

800

2

1

1

1

7

7

1,400

3

1

1

1

7

10

2,000

4

1

1

1

7

13

2,600

5

2

2

2

10

16

3,200

6

2

2

2

10

19

3,800

7

2

2

2

10

22

4,400

8

2

2

2

10

25

5,000

9

3

3

3

13

28

5,600

10

3

3

3

13

31

6,200

11

3

3

3

13

34

6,800

12

3

3

3

13

37

7,400

13

4

4

4

16

40

8,000

14

4

4

4

16

43

8,600

15

4

4

4

16

46

9,200

16

4

4

4

16

49

9,800

  • While more throughput is theoretically possible with 32 Gbit/s or faster connections, the limiting factor is I/O saturation which is occurs at the same rate as 16 Gbit/s connections.

  • For configurations with more than 16 active HANA nodes at a time, contact DataCore Software directly to discuss your requirements.

8 Gbit/s Connections

The following table shows what the minimum DataCore SANsymphony components are required for a specific number of active HANA nodes when using 8 Gbit/s Fibre Channel (FC) connections.

 

Active nodes

 

Front-end Ports

Mirror Ports

 

Back-end Ports

 

DataCore Server CPU Cores

 

Number of Virtual Disks

DataCore SANsymphony Cache Usage (MB)

1

1

1

1

7

4

800

2

1

1

1

7

7

1,400

3

2

2

2

10

10

2,000

4

2

2

2

10

13

2,600

5

3

3

3

13

16

3,200

6

3

3

3

13

19

3,800

7

4

4

4

16

22

4,400

8

4

4

4

16

25

5,000

9

5

5

5

19

28

5,600

10

5

5

5

19

31

6,200

11

6

6

6

22

34

6,800

12

6

6

6

22

37

7,400

13

7

7

7

25

40

8,000

14

7

7

7

25

43

8,600

15

8

8

8

28

46

9,200

16

8

8

8

28

49

9,800

For configurations with more than 16 active HANA nodes at a time, contact DataCore Software directly to discuss your requirements.

Previous Changes

Section(s) Content Changes Date
Certified Configuration Settings – Server Ports

Updated the following:

Server Ports

Changed "FC only" to "FC SCSI only". Added iSCSI and NVMe/oF ports are not certified.

April 2025
The SAP HANA Host- Server Ports

Updated the following:

Server Ports

Changed "FC only" to "FC SCSI only". Added iSCSI and NVMe/oF ports are not certified.

April 2025

All Certified Configuration Settings

Updated the following:

Much of this entire section has changed or been updated for DataCore SANsymphony 10.0 PSP12 and HANA 2.0 certification. A new section for multipath configuration settings specific to SAP HANA hosts has now been added.

July 2021
The DataCore Server

Updated the following:

Server Hardware

This section has been updated and includes a link to all hardware vendors on SAPs own website that can be used for DataCore servers.

SANsymphony Software

The minimum requirement has been amended to now reflect the oldest version of SANsymphony that is not ‘end of life’. Refer to End of life notifications for DataCore Software products FAQ documentation for more information.

April 2021
Certified Configuration Settings – SANsymphony software

Added the following:

Added section discussing Hyper and Hybrid converged installations.

Updated the following:

General

This document has been reviewed for SANsymphony 10.0 PSP 9.No additional settings or configurations are required.

 
Certified Configuration Settings

URL link to SAP’s certified and Supported SAP HANA® Hardware Directory no longer requires a user login.

No technical changes.

March 2019
Certified Configuration Settings

Added the following:

Sizing recommendations - Key Performance Indicators

Updated the following:

Certified configuration settings

Make sure you have re-read this section as it has been completely updated.

A 3-node example

An additional example for the global.ini settings has been included.

December 2018
Certified configuration settings - The Linux host’s requirements

Updated the following:

Certified configuration settings - The Linux host’s requirements

Operating System

SUSE Linux Enterprise Server 11.0 Service Pack 3 or later that is both SAP certified and DataCore supported. Also, refer to "The Linux Configuration Guide" for more information. Previously this stated only ‘SUSE Linux Enterprise Server 11.0 Service Pack 3’ was certified.

HANA Version

  • HANA 2.0 including any SPS.
  • Previously this stated only ‘HANA 2.0’ was certified.
September 2018
General Updates

This document has been reviewed for SANsymphony 10.0 PSP7 Update 2.

No additional settings or configurations are required.

August 2018
General Updates

Updated the following:

  • General:This document has been reviewed for SANsymphony 10.0 PSP 7 update 1. No additional settings or configurations are required.
  • Certified Configuration Settings - Software - All versions of SAP HANA 1.0 SPS09 or greater including version 2.0 are considered certified. Previously it stated SPS09 and SPS10 only.
March 2018
General Updates

Updated the following:

This document has been reviewed for SANsymphony 10.0 PSP6 Update 5. No additional settings or configurations are required.

November 2017
General Updates

Updated the following:

  • General- This document has been reviewed for SANsymphony 10.0 PSP6 Update 2. No additional settings or configurations are required.
  • Certified Configuration Settings - Software - This section has been updated for clarity and information added that was previously documented in 'The host Server – Linux Configuration Guide'.
April 2017
General Updates

Updated the following:

16 Gbit/s Fibre Channel Connections

This has been updated to include 32 Gbit/s Fibre Channel connections.

October 2016
General Updates

Updated the following:

Sizing Recommendations

SANsymphony-V can manage up to 768 active HANA Nodes.

November 2016
Initial Release Initial publication of the document October 2015