To achieve the best storage performance, use the following Linux kernel settings in the SAP HANA VM:
- transparent_hugepage=never
- numa_balancing=disabled
- elevator=noop
- vmw_pvscsi.cmd_per_lun=254
- vmw_pvscsi.ring_pages=32
In a SUSE Linux VM, you can set these parameters by using yast2 and the System Bootloader settings for the kernel parameters. For more information, see the VMware Knowledge Base article Large-scale workloads with intensive I/O patterns might require queue depths significantly greater than Paravirtual SCSI default values.
In addition, change the default maximum I/O size of the Linux kernel from 1,280 KB to
512 KB using udev. Run the following command to create a file named 71-block-max-sectors.rules under /etc/udev/rules.d:
ACTION=="add|change", SUBSYSTEM=="block", RUN+="/bin/sh -c '/bin/echo 512 > /sys%p/queue/max_sectors_kb'"
A reboot is required to activate this setting.
