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.
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. |
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. |