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