Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Storage Configuration Best Practices for SAP HANA TDI with Dell Unity Storage
Executive summary Introduction Technology overview and considerations Storage design recommendations for Dell EMC Unity arrays for SAP HANA Configuring Unity storage for HANA using Dell EMC Unisphere for Unity Accessing Unity storage from the SAP HANA nodes
Overview
Enabling native Linux multipathing (DM-MPIO)
XFS file system
SAP HANA storage connector
SAP HANA global.ini file
Optimizing file I/Os after SAP HANA installation
Conclusion References

Optimizing file I/Os after SAP HANA installation

Home > Workload Solutions > SAP > Guides > SAP HANA TDI Guides > Storage Configuration Best Practices for SAP HANA TDI with Dell Unity Storage > Optimizing file I/Os after SAP HANA installation

Optimizing file I/Os after SAP HANA installation

  • The base layer of HANA provides two file I/O interfaces:

    •  SimpleFile―SimpleFile is used for small, simple I/O requests on configuration files, traces, and so on. It uses lightweight, platform-independent wrappers around system calls.
    •  FileFactory & File―The FileFactory & File I/O interface is used for huge, complex streams of I/O requests on the data and log volumes and for backup and recovery. It uses synchronous and asynchronous I/O operations.

    The SAP HANA file I/O layer can be configured with configuration parameters to optimize file I/Os for a given file system (the Linux XFS file system is used on all Dell EMC storage LUNs for the SAP HANA persistence) and storage array

    After the SAP HANA persistence is installed on Unity LUNs, set the following file I/O layer parameters for optimal I/O processing after the initial SAP HANA installation has been completed:

    • max_parallel_io_requests=128
    • async_read_submit=on
    • async_write_submit_blocks=all

    SAP HANA 1.0

    After the initial SAP HANA installation is complete, set the parameters by using the SAP HANA hdbparam command as <sid>adm in the Linux shell:

    # su - <sid>adm

    # hdbparam –p      # lists current parameter setting

    # hdbparam –-paramset fileio.max_parallel_io_requests=128

    # hdbparam –-paramset fileio.async_read_submit=on

    # hdbparam –-paramset fileio.async_write_submit_blocks=all

    SAP HANA 2.0

    Starting with SAP HANA 2.0, the hdbparam command-line tool has been deprecated. Instead, the parameters are defined as normal parameters in global.ini > [fileio].

    Set the parameter as follows in the global.ini file:

    max_parallel_io_requests=128

    Both async_read_submit=on and async_write_submit_blocks=all are set by default during installation.

    For more information, see SAP Note 2399079: Elimination of hdbparam in HANA 2 (access requires an SAP username and password).

    Note: The previous instructions for tuning file I/O parameters are based on SAP HANA 1.0 SPS 11 and SAP HANA 2.0 SPS01. Future SAP HANA versions might allow these parameters to be set in configuration files. See the latest SAP HANA documentation for more information.