Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

 

Purpose

This page is to explain the steps on how to perform checks if the SAP HANA instance has an issue at hardware or operating system level

 

General Things To Collect

  • Check the operating system error logs (var/log/messages) for signs of errors at hardware level

 

Component Areas for hardware issues:

This depends on your hardware vendor for the device that is giving errors:

Lenovo: BC-OP-LNX-LENOVO

HP: BC-OP-LNX-HP 

Operating System recommendations:

 

SAP Note 2131662 - Transparent Huge Pages (THP) on SAP HANA Servers

SAP Note 1824819 - SAP HANA DB: Recommended OS settings for SLES 11 / SLES for SAP Applications 11 SP2

SAP Note 1954788 - SAP HANA DB: Recommended OS settings for SLES 11 / SLES for SAP Applications 11 SP3

 

Power Saving:

 

SAP Note 1890444 - Slow HANA system due to CPU power save mode

 

Extremely High Memory consumption

 

  • When you run into system hang Situation please do not restart the Database.
  • Instead please take a look into SAP Note 1813020 - How to generate a runtime dump on SAP HANA
  • Generate 3 to 5 dumps on about 30 seconds part.
  • Take a look into these dumps to find out which allocator is taking up the most memory. 
  • Look at SAP Note  1999997  - FAQ: SAP HANA Memory under Q13 for a list of allocator list and their purpose.

 

SAP Note 1858357 - HANA DB: Analysis of wait situations

SAP Note:  1989031 - Scheduling the shell script "thrloop.sh"

CPU maxed out

 

All CPU cores are completely used system wide

  • Check to see if it's HANA process that is consuming most of the CPU.
  • If it is, trigger runtime dump from hdbcons, or use OS tool gstack to trigger thread dump.
  • If it is not, consult with DB admin to see if that process can be terminated or restarted.

SAP Note 1999020 - SAP HANA: Troubleshooting when database is no longer reachable

 

SAP Note 1999670 - Operating system load analysis using "sar"

File System errors

 

SAP Note: 1641148  - HANA server hang caused by GPFS issue

SAP Note 2051052 GPFS "No space left on device" when df shows free space - Lenovo x86_64

  

Common Questions:

The following are problems have been encountered by customers in the past.

 

Q: Can I install 3rd party monitoring of administration software on the HANA appliance?

A.

Their should be no issue with installing monitoring or admin tools on the HANA appliance as per the below notes, SAP allows external tools to be installed on the HANA appliance for admin and monitoring, configuration and support for issues with those tools would be with the manufacturer of the tool.

Please see SAP Notes

1730929 - Using external tools in an SAP HANA appliance

1730996 - Unrecommended external software and software versions

1730928: Using external software in a HANA appliance

Related Documents

 

 

 

 

Related Videos:

 

 

Related SAP Notes/KBAs

SAP Note 1732157 - Collecting diagnosis information for SAP HANA

SAP Note 2083715 - Analyzing log volume full situations

SAP Note 1679938 - Log Volume is full

SAP Note 1788692 - Index Server crash due to missing LogSegment file

SAP Note 1813020 - How to generate a runtime dump on SAP HANA

SAP Note 1858357 - HANA DB: Analysis of wait situations

SAP Note 1989031 - Scheduling the shell script "thrloop.sh"

SAP Note 1999020 - SAP HANA: Troubleshooting when database is no longer reachable

SAP Note 1999670 - Operating system load analysis using "sar"

SAP Note 2123782 - GPFS pagepool size on Lenovo Systems Solution for SAP HANA Platform Edition

SAP Note 1954788 - SAP HANA DB: Recommended OS settings for SLES 11 / SLES for SAP Applications 11 SP3

 

  • No labels