Database Workload Test

This test reports the current CPU usage of the database server to indicate its current load, so that administrators can understand how well the server handles the load and can accurately identify where bottlenecks lie. By comparing the CPU usage of the server with its processing ability, administrators can intelligently figure out if the server requires additional CPU resources for improved performance.

Target of the test : A SAP BTP Neo Environment

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for each Database in the target SAP BTP Neo Environment.

Configurable parameters for the test
Parameter	Description
Test Period	How often should the test be executed
Host	Host name of the server for which the test is to be configured.
PortNo	Enter the port to which the specified host listens. By default, this is 10002.
Subaccount	In SAP Cloud Platform Cockpit, one user account will have multiple subaccounts. So you can mention any one of the subaccount name in the Subaccount text box. To know how to determine the Subaccount, refer to Identifying the API Endpoint URL and Subaccount topic in Pre-requisites for Monitoring SAP BTP Neo Environment.
Database names	Specify a comma-separated list of database names pattern that need to be included for monitoring, by default. To know how to determine the name of Databases, refer to Determining the Name of HANA/ASE Databases to be Monitored topic in Pre-requisites for Monitoring SAP BTP Neo Environment.
User	For collecting the metrics, specify the Username in the User text box. The Username here refers to the Client ID created in SAP Cloud Platform Cockpit. To know how to create such a user (Client ID) in SAP Cloud Platform Cockpit, refer to Registering the eG Agent as an API Client topic in Pre-requisites for Monitoring SAP BTP Neo Environment.
Password	Specify the password in the Password text box. The Password here refers to the Client Secret created in SAP Cloud Platform Cockpit. To know how to create Password (Client Secret) in SAP Cloud Platform Cockpit, refer to refer to Registering the eG Agent as an API Client topic in Pre-requisites for Monitoring SAP BTP Neo Environment.
Confirm Password	Confirm the password by retyping it here in the Confirm Password text box.

Measurements made by the test
Measurement	Description	Measurement Unit	Interpretation
CPU Usage	Indicates the percentage of CPU used by the Database server.	Percent	A value close to 100% is indicative of excessive CPU usage. This in turn indicates that the server is using up all its processing power to service its current workload. It could be because the load is very high. It could also be owing to a few resource-intensive transactions executing on the server. In case of the former, you may want to allocate more CPU resources to the server, so as to enhance its processing ability.
Memory Usage	Indicates the percentage of memory used by the Database server.	Percent	Ideally, the value of this measure should be low. A very high value of this measure could indicate excessive memory consumption by the Database server.
Disk Read	Indicates the rate at which bytes are transferred from the disk during read operations.	KB/Sec	A very high value indicates an bottleneck.
Disk Write	Indicates the rate at which bytes are transferred from the disk during write operations.	KB/Sec	A very high value indicates an bottleneck.