HANA Service Statistics Test

Each of the services executing on the SAP HANA database server consume critical CPU and memory resources of the server. Excessive resource usage by a single service can impact resource availability for other services, thereby adversely impacting the overall performance of the services and the server. Hence, in the event of a slowdown in the operations of the database server, it would be good practice for administrators to take a look at the resource usage of the individual services, so that they can determine whether the poor performance of the server is because one/more services are hogging the resources. To achieve this, administrators can use the HANA Service Statistics test. For each service running within SAP HANA, this test reports the CPU and memory usage of the service, thus enabling administrators to accurately identify resource-hungry services that can potentially cause server performance to degrade.

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 service of the SAP HANA database 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.
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.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Process CPU Usage	Indicates the percentage of CPU that is used by the current process that is associated with this service.	Percent
Total CPU Usage	Indicates the total percentage of CPU used by all processes that are associated with this service.	Percent	A high value or a consistent increase in the value of this measure is a cause for concern, as it indicates abnormal CPU usage by the service.
Process Logical Memory	Indicates the amount of logical memory used by this service.	MB	Ideally, the value of these measures should be low. Compare the value of each of these measures across services to identify that service that is engaging in memory-intensive operations.
Process Physical Memory	Indicates the amount of physical memory used by this service.	MB
Used Memory	Indicates the amount of memory used by this service in the SAP HANA database server.	MB	The value of this measure constitutes both physical memory and swap memory usage. Compare the value of this measure across all the services to identify the service that is consuming memory resources excessively.
Free Memory	Indicates the amount of memory that is currently available for use by this service.	MB	This value is the sum of free physical memory and free swap memory. Ideally, this value should be high for a service. A consistent drop in the value of this measure is indicative of a memory-hungry service, which can, in the long run, cause a severe memory contention within SAP HANA.
Total Memory	Indicates the total amount of memory used by this service.	MB	The total memory constitutes both physical memory and swap memory.
Percentage of Free Memory	Indicates the percentage of memory (both physical memory and swap memory) that is currently available for use by this service.	Percent	A high value is desired for this measure. A consistent decrease in this value indicates that the service is steadily draining SAP HANA off its memory resources.
Physical Memory Usage	Indicates the percentage of physical memory that is currently used by this service.	Percent	A low value is desired for this measure. A consistent increase in this value indicates that the service is steadily draining SAP HANA off its memory resources.