It is possible to configure the SAP HANA file I/O layer with certain parameters to optimize file IOPS for a specific storage solution and file system. The Linux XFS file system is used on all storage volumes for the SAP HANA persistence.

Setting file I/O layer parameters in SAP HANA 1.0 installations

As <sid>adm, run the SAP HANA hdbparam command in the Linux shell:

su - <sid>adm

hdbparam –p      # lists current parameter setting

hdbparam –-paramset fileio.max_parallel_io_requests[Data]=128

hdbparam –-paramset fileio.max_parallel_io_requests[Log]=128

Setting file I/O layer parameter in SAP HANA 2.0 installations

Use either hdbsql or the SQL function in SAP HANA Studio or Cockpit and run the following SQL commands:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio', 'max_parallel_io_requests[Data]') = '128' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio', 'max_parallel_io_requests[Log]') = '128' WITH RECONFIGURE;

For more information, see SAP Note 2399079: Elimination of hdbparam in HANA 2 (access requires SAP login credentials).