SAP Note 2205917 - SAP HANA DB: Recommended OS settings for SLES 12 / SLES for SAP Applications 12

Component : SAP HANA Database - SUSE Linux

Solution : https://service.sap.com/sap/support/notes/2205917 (SAP Service marketplace login required)

Summary :
This SAP Note provides guidance for optimal configuration of SAP HANA on SLES 12 and its derivatives to enhance performance. Key recommendations include disabling Transparent HugePages (THP) to prevent potential performance issues due to HANA's memory management characteristics. Additionally, configuration adjustments are advised for disabling Intel's CPU idle states (C-States) and the intel_idle driver for lower latency. Users should also consider adjusting the Energy Performance Bias (EPB) to enhance throughput in computational scenarios. Furthermore, AutoNUMA should be disabled to prevent performance degradations, particularly in single instance environments. Each setting imposes commands for verification and modification via system command lines or through the YaST2 bootloader interface.

Key words :
components bc-op-lnx-suse suse linux priority recommendations / additional info category consulting validity software componentfrom rel, general information 2309342   suse linux enterprise high availability extension, # cat /sys/devices/system/cpu/cpuidle/current_driver, customer component han-db sap hana database, runtime execute     # echo 0 > /proc/sys/kernel/numa_balancing, appending         numa_balancing=disabled   linux pagecache limit configuring, supported operating systems 1890444   slow hana system due, central note 1310037   suse linux enterprise server 11, cpu power save mode 1523337   sap hana database 1, # cat /sys/kernel/mm/transparent_hugepage/enabled

Related Notes :

1557506Linux paging improvements
2246163
2235581SAP HANA: Supported Operating Systems
1890444Slow HANA system due to CPU power save mode
1523337SAP In-Memory Database 1.0: Central Note
1514967SAP HANA 1.0: Central Note
1310037SUSE LINUX Enterprise Server 11: Installation notes
171356SAP software on Linux: General information
2309342SUSE Linux Enterprise High Availability Extension on AWS
1944799SAP HANA Guidelines for SLES Operating System Installation