cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

SAP HANA 2.0.apm-template

This Template contains ODBC application monitors containing HANA queries to fetch the performance statistics of HANA 2.0 Express Edition database.

Some of the counters may require manual configuration, such as setting up installation-specific instances, correcting thresholds for the client’s environment, and so forth.

Prerequisites: SAP HANA 2.0 Express Edition as a monitored server.

Credentials: ODBC Credentials to access SAP HANA 2.0 Express Edition.

How to Apply this Template

  1. Add a node of the URL / IP (i.e. Hana Instance) which you want to monitor/connect with polling method as ‘External’.
  2. Create a Monitoring Credential to access that added URL ( Hana Instance )
  3. Assigned the HANA Template and the credential (created in step 2) to the node added in step 1.

Portions of this document were originally created by and are excerpted from the following sources:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/1.0.12/en-US/b4b0eec1968f41a099c828a4a6...

https://anibalg.files.wordpress.com/2012/08/hana_monitor_views_en.pdf

http://sap.optimieren.de/hana/hana/html/monitor_views.html

MONITORED COMPONENTS

CPU Utilization %

This monitor value is being calculated using table HOST_RESOURCE_UTILIZATION_STATISTICS.

When sum of TOTAL_CPU_USER_TIME_DELTA, TOTAL_CPU_SYSTEM_TIME_DELTA, TOTAL_CPU_WIO_TIME_DELTA & TOTAL_CPU_IDLE_TIME_DELTA from the query output is greater than 1 then the value will be calculated as CPU Utilization %:

Addition of User CPU & System CPU and divide by sum of all types of CPUs from the query output. If CPU is already 0 then no further calculation and 0 is returned. The monitor value will be up to 3 decimal points.

Reference URL: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/1.0.12/en-US/fbd82f0303c44e35a6bbb12cb8...

I/O Read Throughput in MB - DATA volume

Data I/O read throughput: The monitor value is being calculated using two tables: M_VOLUME_IO_TOTAL_STATISTICS_RESET and M_VOLUMES.

When volume id of both the tables’ matches and their type is 'DATA' and service name is 'indexserver' then the value will be calculated as total_read_size/total_read_time (MB).

If total_read_time value is 0 then total_read_time will be set as -1 in the calculation. The monitor value will be up to 3 decimal points.

Reference URLs:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cadec8751910148bab98528e...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cb024a75191014a582b6feef...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cb3e1975191014a6979aa897...

I/O Read Throughput in MB - LOG Volume

I/O Read Throughput (in Mb) LOG volume: The monitor value is being calculated using two tables: M_VOLUME_IO_TOTAL_STATISTICS_RESET and M_VOLUMES.

When volume id of both the tables’ matches and their type is 'LOG' and service name is 'indexserver' then the value will be calculated as total_read_size/total_read_time (MB).

If total_read_time value is 0 then total_read_time will be set as -1 in the calculation. The monitor value will be up to 3 decimal points.

Reference URLs:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cadec8751910148bab98528e...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cb024a75191014a582b6feef...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cb3e1975191014a6979aa897...

I/O Write Throughput in MB - DATA Volume

I/O Write Throughput MB DATA volume: The monitor value is being calculated using two tables: M_VOLUME_IO_TOTAL_STATISTICS_RESET and M_VOLUMES.

When volume id of both the tables’ matches and their type is 'DATA' and service name is 'indexserver' then the value will be calculated as total_write_size/total_write_time (MB).

If total_write_time value is 0 then total_write_time will be set as -1 in the calculation. The monitor value will be up to 3 decimal points.

Reference URLs:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cadec8751910148bab98528e...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cb024a75191014a582b6feef...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cb3e1975191014a6979aa897...

I/O Write Throughput in MB - LOG Volume

I/O Write Throughput in MB - LOG Volume: The monitor value is being calculated using two tables: M_VOLUME_IO_TOTAL_STATISTICS_RESET and M_VOLUMES.

When volume id of both the tables’ matches and their type is 'LOG' and service name is 'indexserver' then the value will be calculated as total_write_size/total_write_time (MB).

If total_write_time value is 0 then total_write_time will be set as -1 in the calculation. The monitor value will be up to 3 decimal points.

Reference URLs:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cadec8751910148bab98528e...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cb024a75191014a582b6feef...

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20cb3e1975191014a6979aa897...

System Memory Used %

This monitor retrieves the system memory (in percent) currently being used by the SAP HANA indexserver via M_MEMORY table.

Reference URLs:

https://anibalg.files.wordpress.com/2012/08/hana_monitor_views_en.pdf

http://sap.optimieren.de/hana/hana/html/monitor_views.html

Heap Memory Used %

This monitor retrieves the heap memory (in percent) currently being used by the SAP HANA indexserver via M_MEMORY table.

Reference URLs:

https://anibalg.files.wordpress.com/2012/08/hana_monitor_views_en.pdf

http://sap.optimieren.de/hana/hana/html/monitor_views.html

Connections

This monitor fetches the count of connections from the M_CONNECTIONS table.

Reference URL: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20abcf1f75191014a254a82b3d...

Active Statements

This monitor fetches the count of active statements from the M_ACTIVE_STATEMENTS table.

Reference URL: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/d20500acd2951014b54ce5af8c...

Active Procedures

This monitor fetches the count of active procedures from the M_ACTIVE_PROCEDURES table.

Reference URL: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/f3d23305d0dd495590e0061c35...

Table Lock Count

This monitor fetches the count of table locks from the M_TABLE_LOCKS table.

Reference URL: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/8d163cd6735e4923ad8f967779...

Record Lock Count

This monitor fetches the count of record locks from the M_RECORD_LOCKS table.

Reference URL: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20b8665a751910148dd0e46c9b...

Blocked Transaction Count

This monitor fetches the count of blocked transactions from the M_BLOCKED_TRANSACTIONS table.

Reference URL: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20a8c51d75191014b6c0e177ae...

Labels (1)
Attachments
Comments

Hi,

Could you please let me know what level of credentials are required on SAP Hana instance.

can we have more detailed steps of how this can be achieved.. current details are not giving clarity....

can we have more detailed steps of how this can be achieved.. current details are not giving clarity....

Version history
Revision #:
1 of 1
Last update:
‎08-09-2018 12:39 PM
Updated by: