SAP Note 2267798 sets out how a customized SAP HANA configuration file can be used to set out during the installation procedure for both scale up and scale out deployments.
With HANA 2.0 the hdbparam tool has been depreciated. See SAP Note 2399079. The parameters can now be found in Configuration -> Global.ini->fileio.https://launchpad.support.sap.com/#/notes/2399079
To get the optimal usage of the storage subsystem, set the parameters to the following values:
|
fileio.num_completion_queues |
8 |
|
fileio.num_submit_queues |
8 |
|
fileio.size_kernel_io_queue |
512 |
|
fileio.max_parallel_io_requests |
64 |
|
fileio.min_submit_batch_size |
16 |
|
fileio.max_submit_batch_size |
64 |
|
fileio.async_write_submit_active |
on |
|
fileio.async_write_submit_blocks |
all |
|
fileio.async_read_submit |
on |