HANA Host Memory Test

By proactively detecting a potential memory contention on a SAP HANA server, administrators can easily avert slowdowns or outages of the SAP HANA database server. The HANA host Memory test helps administrators in this exercise. This test reports how well the SAP HANA server uses the physical and swap memory allocated to it, and leads administrators to abnormal memory usage patterns (if any).

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 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
Total Physical Memory	Indicates the total amount of physical memory allocated for the SAP HANA database server.	MB
Free Physical Memory	Indicates the amount of physical memory that is currently available on the SAP HANA database server.	MB	A high value is desired for this measure.
Used Physical Memory	Indicates the amount of physical memory that is currently used by the SAP HANA database server.	MB	Ideally, the value of this measure should be low. A consistent increase in this value could be a cause for some serious concern, as it indicates a gradual, but steady erosion of valuable memory resources. If this unhealthy trend is not repaired soon, it could severely hamper server performance, causing anything from a slowdown to a complete system meltdown.
Total Swap Space	Indicates the total amount of swap memory allocated for the SAP HANA database server.	MB	Swap space is space on a hard disk used as the virtual memory extension of a computer's real memory (RAM). The least recently used files in RAM can be "swapped out" to the hard disk until they are needed later so that new files can be "swapped in" to RAM.
Free Swap Space	Indicates the amount of swap memory that is currently available for the SAP HANA database server.	MB	Ideally, the value of this measure should be high, as having an appropriate amount of swap space is important for optimal system performance.
Used Swap Space	Indicates the amount of swap memory that is currently used by the SAP HANA database server.	MB	A consistent rise in the value of this measure is a cause for concern.
Percentage of Free Physical Memory	Indicates the percentage of physical memory that is currently available on the SAP HANA database server.	Percent	A high value is desired for this measure. A consistent drop in this value is a sign that physical memory is being over-utilized by the server.
Percentage of Free Swap Space	Indicates the percentage of swap memory that is currently available on the SAP HANA database server.	Percent	A very low value indicates that the swap space configured may not be sufficient. A value close to 100% may imply that the swap space configured may be too large.