HANA XS Summary Test

This test monitors the target SAP HANA XS Advanced system and reports the status of the server and the number of used applications and instances. In addition, this test also reveals number of stopped and crashed instances, deployed, running and stopped applications, and total alerts in last 5 minutes. The detailed diagnostics provided by this test points administrators precisely to the XS organization, XS space, username and total applications for which alerts occurred in last 5 minutes.

Target of the test : A SAP HANA XS advanced Application server

Agent deploying the test : A remote agent

Outputs of the test : One set of results for the target 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.

Organization

Specify the name of the Organization that contains the spaces in which the applications are deployed on HANA XS in this text box. Example: org

Spaces

Specify a comma-separated list of Spaces for the specified Organization in HANA XS in this text box. The Spaces specified in this text box need to be included for monitoring. Example: SAP,PROD

XS Path

Specify the full path to the location where the HANA XS is installed in this text box. Example: /HANA/shared/HDB/xs/bin/

CLI User

Typically, to connect to a HANA XS and run tests, the eG agent requires the permissions of a HANA XS client user who has been assigned the role collections as XS_CONTROLLER_ADMIN_READ_ONLY, also assigned the OrgAuditor, SpaceAuditor roles for specified organization and spaces. Ideally, you will have to create a new user role on the HANA XS for this purpose, associate the above-mentioned collections with that role, and assign the new role to an existing HANA XS client user. Once the new role is assigned to a HANA XS client user, specify the name of this user against CLI User text box.

Example: To create user as XSA_ADMIN2. Execute below query in SAP HANA studio.

CREATE USER XSA_ADMIN2 PASSWORD “admin”;

Assign roles for HANA XS CLI user using HANA XS Client commands mentioned below:

  • xs assign-role-collection XS_CONTROLLER_ADMIN_READ_ONLY XSA_ADMIN2;

  • xs set-org-role XSA_ADMIN2 orgname OrgAuditor;

  • xs set-space-role XSA_ADMIN2 SAP SpaceAuditor;

CLI Password

Specify the password of the specified CLI User in this text box.

Confirm Password

Confirm the password by retyping it in this text box.

CLI Location

The XS CLI client tools are installed by default on the SAP HANA server. However, you can also download and install the client tools locally, if you want to connect to SAP HANA from your local machine. Hence, set this flag to Remote or Local based on the location of HANA XS Client.

CLI Endpoint

Specify the URL of the API end point to connect to the XS advanced controller on the SAP HANA server in this text box. Syntax for this CLI endpoint is : https://<Hostname>: 3<Instance Number>30. Example: https://vhcalhdbdb.dummy.nodomain:30030.

Detailed Diagnosis

To make diagnosis more efficient and accurate, the eG Enterprise embeds an optional detailed diagnostic capability. With this capability, the eG agents can be configured to run detailed, more elaborate tests as and when specific problems are detected. To enable the detailed diagnosis capability of this test for a particular server, choose the On option. To disable the capability, click on the Off option.

The option to selectively enable/disable the detailed diagnosis capability will be available only if the following conditions are fulfilled:

  • The eG manager license should allow the detailed diagnosis capability
  • Both the normal and abnormal frequencies configured for the detailed diagnosis measures should not be 0.
Measurements made by the test
Measurement Description Measurement Unit Interpretation

Status

Indicates the current state of this server.

 

The values reported by this measure and their numeric equivalents are available in the table below:

Measure Value Numeric Value
STARTUP 0
READY 1
INSTALLATION PENDING 2
UPDATE PENDING 3

Note:

By default, this measure reports the Measure Valueslisted in the table above to indicate the current state of the target server. In the graph of this measure however, the same will be represented using the numeric equivalents only.

Applications used

Indicates the total number of used applications on the target server.

Number

 

Instances used

Indicates the total number of used instances on the target server.

Number

 

Starting instances

Indicates the number of starting instances on the target server.

Number

 

Running instances

Indicates the number of running instances on the target server.

Number

 

Stopped instances

Indicates the number of stopped instances on the target server.

Number

A low value is desired for this measure.

Crashed instances

Indicates the number of crashed instances on the target server.

Number

A low value is desired for this measure.

Timed out instances

Indicates the number of timeout instances on the target server.

Number

 

Deployed applications

Indicates the number of applications deployed on the target server.

Number

 

Running applications

Indicates the number of applications currently running on the target server.

Number

 

Stopped applications

Indicates the number of stopped applications on the target server.

Number

 

Total alerts in last 5 minutes

Indicates the total number of alerts occurred in last 5 minutes.

Number

The detailed diagnosis of this measure lists the details of XS organization, XS space, username, total applications, number of five minutes alerts, and bound services.