Home > Workload Solutions > SAP > Guides > SAP HANA TDI Guides > Dell Validated Design for SAP HANA TDI with Dell PowerStore Storage > File I/O optimization
The base layer of SAP HANA provides two file I/O interfaces:
You can configure the SAP HANA file I/O layer to optimize file I/O for a specific file system and storage system.
Note: The Linux XFS file system is used on all Dell storage volumes for the SAP HANA persistence.
SAP HANA 1.0
After the initial SAP HANA installation is complete, set the parameters by running the A hdbparam command as <sid>adm in the Linux shell:
su - <sid>adm
hdbparam –p # lists current parameter setting
hdbparam –-paramset fileio [DATA].max_parallel_io_requests=128
hdbparam –-paramset fileio [LOG].max_parallel_io_requests=128
hdbparam –-paramset fileio [DATA].max_submit batch size=128
hdbparam –-paramset fileio [LOG]. max_submit batch size =128
hdbparam –-paramset fileio [LOG].num_completion_queues=4
hdbparam –-paramset fileio [LOG]. num_submit_queues=8
SAP HANA 2.0
Effective from SAP HANA 2.0, the hdbparam command-line tool has been deprecated. Instead, the parameters are defined as normal parameters in global.ini > [fileio]. Using the SQL console in the SAP HANA Cockpit, set the parameters in the global.ini file by running the following commands:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[DATA]') = '128';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[LOG]') = '128';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_submit_batch_size[DATA]') = '128';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_submit_batch_size[LOG]') = '128';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','num_completion_queues[LOG]') = '4';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','num_submit_queues[LOG]') = '8' WITH RECONFIGURE
The following figure shows what the fileio section of global.ini looks like after the parameters are set:
All other parameters are set by default during installation. For more information, see SAP Note 2399079: Elimination of hdbparam in SAP HANA 2 (access requires SAP login credentials).