HANA Volume Files Test
Since the SAP HANA database resides in volatile main memory, a persistency layer in the SAP HANA database engine ensures the durability of the transactions. In the event of a failure the persistency layer ensures that the database can be restored to the most recent committed state after a restart. Transactions are either completely executed or completely un-done. To ensure durability of data changes completed in the memory of the SAP HANA server nodes, database data is written to disks. The persistency layer stores data in disk volumes, organized in pages. There are two types of volumes: data and log. Every process/service in the SAP HANA database which needs to persist data, such as the name, index and statistic servers, writes regularly into its own data and log volume. The data volume contains data pages and undo log information. The log volume only records redo log information. In the event of a crash or recovery, redo log information is used to roll forward changes that have not been persisted on the data pages while undo log information is used to roll back changes for uncommitted transactions. If the data or log volume mapped to a service does not have sufficient free space, then these volumes will not be able to store critical undo/redo log details and data pages, thus causing the disaster recovery engine of the database server to fail! This in turn may cause critical data loss and service failures! To prevent such irredeemable losses, it is of utmost importance to closely monitor the space usage in the data and log volumes of each service, detect a space crunch even before it occurs, and right-size the volumes accordingly. To help administrators with this, the eG agent runs the HANA Volume Files test on the SAP HANA database server.
For each service of the SAP HANA database server, this test reports how that service uses each of its disk volumes (data or log), thereby pointing administrators to services that are over-utilizing their volumes and may require additional space if any permanent damage to performance is to be averted.
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 volume type (data or log) of each service of 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 |
---|---|---|---|
Used Size |
Indicates the amount of space that this service is currently using in this volume. |
MB |
A low value is desired for this measure. |
Used Percent |
Indicates the percentage of space that this service is currently using in this volume. |
Percent |
A low value is desired for this measure. If a consistent growth is noticed in the value of this measure, it is indicative of gradual erosion of space in a disk volume. You may want to free up more space by either adding more disks or by removing unnecessary or obsolete files from the disk. This depends upon the volume type. For instance, in case of the data volume, you must not delete files from this volume manually, as it can corrupt the SAP HANA system. On the other hand, if the trace volume runs out of space, you can delete the trace files to make room for more trace data. |
Growth |
Indicates the rate at which this volume file has grown since the last measurement period. |
MB/Sec |
If a consistent growth is noticed, it is indicative of gradual erosion of space in a disk volume. You may want to free up more space by either adding more disks or by removing unnecessary or obsolete files from the disk. This depends upon the volume type. For instance, in case of the data volume, you must not delete files from this volume manually, as it can corrupt the SAP HANA system. On the other hand, if the trace volume runs out of space, you can delete the trace files to make room for more trace data. |