Solution : https://service.sap.com/sap/support/notes/2131662 (SAP Service marketplace login required)
Summary :
Symptom: SAP HANA database experiences high CPU load, hanging, and severe performance issues when Transparent Huge Pages (THP) are activated. Reason: THP enabled on HANA servers causes database instability and potential standstill. Solution: SAP strongly recommends disabling THP on SLES 11 SP2 and SP3 environments. Command provided for disabling THP. References include related SAP Notes on recommended OS settings for SLES 11.
Key words :
> /sys/kernel/mm/transparent_hugepage/enabled cat /sys/kernel/mm/transparent_hugepage/enabled, components bc-op-lnx-suse suse linux priority correction, cat /sys/kernel/mm/transparent_hugepage/enabled [, customer component han-db sap hana database, high priority category external error validity, sap applications 11 sp3 1523337 sap hana database 1, sap notes 1954788 sap hana db, prerequisites activated transparent huge pages, / __%pdfstyle%__font-size, __%pdfstyle%__ / } symptom
Related Notes :
| 1954788 | SAP HANA DB: Recommended OS settings for SLES 11 / SLES for SAP Applications 11 SP3 |
| 1523337 | SAP In-Memory Database 1.0: Central Note |
| 1514967 | SAP HANA 1.0: Central Note |
| 2093754 | SAP HANA DB: Known issues detected in SPS09 |