Solution : https://service.sap.com/sap/support/notes/1824819 (SAP Service marketplace login required)
Summary :
This SAP Note details configuring HANA DB optimization on SLES 11 SP2 or SAP variant for enhanced performance. Key actions include disabling Transparent Hugepages due to potential performance issues with HANA, overriding default settings that activate these in the Linux kernel. Additionally, C-states configuration modification for lower latency and peak performance is outlined. Disabling the 'intel_idle' driver via bootloader configuration ensures consistent low-latency operation by reverting to the recommended 'acpi_idle' driver. Furthermore, for systems using XFS for data storage, patch information regarding an inconsistency bug is provided. These solutions require root access and may vary with new kernel releases.
Key words :
cat /sys/devices/system/cpu/cpuidle/current_driver, read note 1867783 - xfs data inconsistency bug, > /sys/kernel/mm/transparent_hugepage/enabled, translation lookaside buffer footprint, current active bootloader located, configure optimal linux settings, xfs locking problem, sap hana data-, configure optimal settings, system boot scripts
Related Notes :
| 1890444 | Slow HANA system due to CPU power save mode |
| 1523337 | SAP In-Memory Database 1.0: Central Note |
| 1514967 | SAP HANA 1.0: Central Note |
| 1310037 | SUSE LINUX Enterprise Server 11: Installation notes |