HANA SQL Connectivity Test
This test reports the availability and responsiveness of the SAP HANA database server.
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 each volume that is to be 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 |
---|---|---|---|
Availability |
Indicates the availability of this SAP HANA database server. |
Number |
A value of 100 indicates that the SAP HANA database server is available and a value 0 indicates that the database server is not available. |
Response Time |
Indicates the time taken by this SAP HANA database server to respond to a user request. |
Secs |
Ideally, the value of this measure should be low. A sudden increase in response time is indicative of a bottleneck at the database server. This could even be owing to a connection delay and/or long running queries to the database. |