HANA XS Blob Storage Test

Blob store is used for storing binary large objects or blobs which are typically composed of unstructured data such as text, images, and videos, along with their metadata. In the context of XS advanced, the Blob Store resides in the SAP HANA database and is used to store build packs along with run-time environments and applications. This test discovers the blob store residing in the SAP HANA database and reports the size of blob set, unique blobs and shared blobs. This test also reveals the failures occurred while storing blobs in the blob store such as simple and bulk update failures, cleanup failures and statement failures. This test also tracks the number of operation failures such as bulk add and clean up operations along with average clean up time. This way, the test not only leads administrators to the problem areas of a storage account, it also reveals the probable cause of these problems, thereby enabling administrators to act quickly and eliminate the issues.

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.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Blob set size

Indicates the size of blob sets in the blob store.

GB

 

Unique blobs size

Indicates the size of unique blobs in the blob store.

GB

 

Shared blobs size

Indicates the size of shared blobs in the blob store.

GB

A low value is desired for this measure.

Single statement failures

Indicates the number of single statement failures in the blob store.

Number

A low value is desired for this measure.

Bulk update failures

Indicates the number of bulk update failures in the blob store.

Number

A low value is desired for this measure.

Simple update failures

Indicates the number of simple update failures in the blob store.

Number

A low value is desired for this measure.

Failed bulk add operations

Indicates the number of bulk add operations that failed.

Number

A low value is desired for this measure.

Failed cleanup operations

Indicates the number of cleanup operations that failed.

Number

 

Average cleanup time

Indicates the average time taken for cleanup operation.

Seconds