HANA Service Threads Test

By closely monitoring thread usage of each of the services of a SAP HANA database server, administrators can gauge the workload generated by every service and how well each service handles the load. The HANA Service Threads test does just that! This test reports the count of threads that services requests for a service and the maximum time that the threads took to process service requests. In the process, the test indicates how busy a service is, and points to those services that may run into a processing bottleneck.   

Target of the test : A SAP HANA Database Server

Agent deploying the test : A remote agent

Outputs of the test : One set of results for every Thread: Service of the SAP HANA database server being monitored.

Configurable parameters for the test
Parameter Description

Test period

How often should the test be executed

Host

The host for which the test is to be configured.

Port

The port number at which the specified Host listens to. By default, this will be 30015.

User

In order to monitor a SAP HANA database server, a special database user account with Monitoring privileges has to be created in every SAP HANA database instance that requires monitoring. The syntax of the script that is used for user creation is discussed in How to Monitor SAP HANA Database Server Using eG Enterprise?.

The name of such a user has to be specified here.

Password

Enter the password of the specified User.

Confirm Password

Confirm the password by retyping it here.

IsPassive

If the value chosen for this parameter is Yes, then the SAP HANA database server under consideration is a passive server in a SAP HANA cluster. No alerts will be generated if the server is not running. Measures will be reported as “Not applicable” by the agent if the server is not up.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Thread Count

Indicates the number of threads that are currently handling the requests for this service.

Number

This is a good indicator of the workload generated by a service on SAP HANA.

Longest Thread

Indicates the maximum time that a thread took to serve requests for this service.

MilliSec

A high value for this measure is a cause of concern, as it could indicate a potential service slowdown.