HANA Uptime Test
Frequent database restarts or intermittent breaks in database availability are signs of poor database server health. Administrators hence need to track the uptime of each database in SAP HANA, so that they can quickly compare that with service level targets to identify trouble-prone or unstable databases. To achieve this, administrators can use the HANA Uptime test. This test auto-discovers the databases on SAP HANA and reports the uptime of each database, so that those databases that went down frequently can be identified.
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 database on 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 | ||||||
---|---|---|---|---|---|---|---|---|---|
Uptime |
Indicates the total time for which this database was up since its last reboot. |
Mins |
A low value for this measure may be either due to planned maintenance of the database or a severe problem with the availability of the database. to determine such conditions. |
||||||
Has the HANA server been restarted? |
Indicates whether/not the HANA server was restarted during the last measurement period. |
|
If the server was restarted, this measure will report the value Yes. If it was not restarted, then this measure will report the value No. The numeric values that correspond to these measure values are as follows:
Note: By default, this measure reports the Measure Values in the table above to indicate whether/not the server rebooted. However, in the graph of this measure, the same is represented using the numeric equivalents only. |