Skip to main content

Execute HANASitter for hang situation analysis



The SAP HANAsitter is configured to perform default checks once every hour to ascertain the online and primary status of SAP HANA. Upon confirmation, it initiates tracking procedures, which involve regular responsiveness assessments (typically every minute). If SAP HANA becomes unresponsive, the HANAsitter commences recording activities, potentially capturing call stacks of active threads, run-time dumps, index server gstacks, and/or kernel profiler traces, although, by default, no recording occurs. When SAP HANA is responsive, the script scrutinizes critical features, including a standard check for more than 30 active threads. If this threshold is exceeded, the script triggers recording. Upon completing the recording process, the script exits, with an option to be configured for restart using the command line.

Setup Steps Overview:

  • Begin by creating an SAP HANA user with the desired name (e.g., HANASITTER) and assign the CATALOG READ privilege to it.
  • Establish a user key in the hdbuserstore, choosing a name like SYSTEMKEY (customizable to your preference).
  • Download the hanasitter.py script from SAP Note 2399979.
  • Save the script, preferably in the python_support directory.
  • Switch to the python_support directory using the command cdpy, assuming the role of <sid>adm.
  • Execute the script by using the command python hanasitter.py -ng 1

The hanasitter performs a series of essential checks, including:

Database Online Check:

    Ensuring the database is online and accessible.
    CPU, Ping, and Critical Feature Check:

    Verifying CPU functionality, network connectivity through     ping, and critical feature validation.

Recording Mode for RTE Dumps, Stack Calls, Kernel Profiler Trace, and GStack:

    Activating recording modes for Runtime Error (RTE) dumps,     stack calls, kernel profiler trace, and GStack for            comprehensive diagnostic insights.

Scale-Out Monitor:

    Monitoring and assessing the status of scale-out            configurations.

Critical Session Killer:

   Implementing a critical session killer mechanism to handle    high-priority session management.




Labels:

Comments

Post a Comment

You might find these interesting

8 Must-Know Questions About Object Store on SAP Business Technology Platform

What is the problem that Object Store solves ? Modern enterprise systems increasingly deal with massive volumes of unstructured data such as documents, logs, media files, and backups. Traditional relational databases are not optimized for such workloads. What is Object Store ? Object storage—commonly referred to as blob storage—addresses this gap by providing scalable, durable, and cost-efficient storage for unstructured data. Object storage is a storage architecture designed to manage unstructured data as discrete units called objects.  Each object consists of: Binary data (file content) : Image , File etc Metadata (descriptive attributes) : File size, Content type, Last modified timestamp, Storage class (hot, cool, archive) Unique identifier (key or URL) : unique path-like string used to locate a blob inside a bucket Unlike file systems or relational databases, object storage does not rely on hierarchical file structures or schemas. The SAP BTP Object Store service is a managed, ...
Post a Comment
Read more