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