Viewing Monitoring Metrics

You can view the host OS metrics and SAP system metrics reported to AOM.

Procedure

Log in to the management console.
In the navigation pane on the left, click and choose Management & Governance > Application Operations Management.
In the navigation pane on the left on the displayed page, choose Monitoring > Metric Monitoring to view the SAP system metrics and host OS metrics.

Host OS Metrics

For details about the host OS metrics of AOM, see Metric Overview.

SAP System Metrics

SAP system metrics are classified into SAP HANA metrics as well as SAP NetWeaver ABAP and SAP NetWeaver Java application metrics, as shown in:

Table 1

Table 2

**Table 1** SAP HANA metrics
Metric Group	Metric Name	Description	Unit
database_version	sap_hanadb_database_version_info	Database version
service_quantity	sap_hanadb_service_quantity_count	Total number of instance processes	count
service_quantity	sap_hanadb_active_service_quantity_count	Number of active processes in an instance	count
database_ha_active	sap_hanadb_database_ha_active_status	Database HA status	status
sr_active	sap_hanadb_sr_active_status	Database system replication status	status
threads	sap_hanadb_all_threads_count	Total number of threads	count
	sap_hanadb_active_threads_count	Number of active threads	count
	sap_hanadb_blocked_threads_count	Number of blocked threads	count
	sap_hanadb_sqlexecutor_threads_count	Number of SQL execution threads	count
	sap_hanadb_sqlexecutor_threads_active_count	Number of active SQL execution threads	count
	sap_hanadb_jobworker_threads_count	Total number of job threads	count
	sap_hanadb_jobworker_threads_active_count	Number of active job threads	count
recent_data_backup	sap_hanadb_age_of_recent_data_backup_hours	Number of hours since the last successful full data backup If the backup fails, the value is -1.	hours
recent_savepoint	sap_hanadb_age_of_recent_savepoint_minutes	Number of minutes since last SAVEPOINT If the SAVEPOINT does not exist, the value is -1.	minutes
recent_savepoint	sap_hanadb_recent_savepoint_duration_seconds	Duration (in seconds) of the last SAVEPOINT If the SAVEPOINT does not exist, the value is -1.	seconds
column_tables_used_memory	sap_hanadb_column_tables_used_memory_mb	Memory usage of the data table	mb
schema_used_memory	sap_hanadb_schema_used_memory_mb	Database schema memory usage	mb
disk_data_files	sap_hanadb_disk_data_files_used_size_mb	Used space per file and file type (in MB)	mb
	sap_hanadb_disk_data_files_total_size_mb	Total space per file and file type (in MB)	mb
	sap_hanadb_disk_data_files_available_size_mb	Available space per file and file type (in MB)	mb
	sap_hanadb_disk_data_files_fragmentation_percent	Percentage of unused space compared to total space in file	percent
disk_usage	sap_hanadb_disk_total_device_size_mb	Total device size returned by the operating system (in MB). It will be repeated if the device is shared between usages_types.	mb
	sap_hanadb_disk_total_size_mb	Volume size in MB. It will be repeated if the volume is shared between usages_types.	mb
	sap_hanadb_disk_total_used_size_mb	Used volume size in MB. It will be repeated if the volume is shared between usages_types.	mb
	sap_hanadb_disk_used_size_mb	Used disk size calculated for each usage type (such as DATA and LOG)	mb
service_memory	sap_hanadb_memory_service_shared_allocated_mb	Shared memory in MB allocated from the memory pool to the service	mb
	sap_hanadb_memory_service_shared_used_size_mb	Used Shared Memory part of the memory pool per service in MB	mb
	sap_hanadb_memory_service_shared_used_percent	Percentage of used Shared Memory from the memory pool per service	percent
	sap_hanadb_memory_service_heap_allocated_mb	Heap memory allocated from the memory pool to the service	mb
	sap_hanadb_memory_service_heap_used_size_mb	Used Heap Memory part of the memory pool per service in MB	mb
	sap_hanadb_memory_service_heap_used_percent	Percentage of used Heap Memory part of the memory pool per service	percent
	sap_hanadb_memory_service_total_used_mb	Total memory that has been applied for from the memory pool for the service	mb
	sap_hanadb_memory_service_physical_total_mb	Total physical memory used by the service	mb
	sap_hanadb_memory_service_virtual_total_mb	Total virtual memory used by the service	mb
	sap_hanadb_memory_service_code_size_mb	Size of the code snippet used by the service (including the dynamic link library)	mb
	sap_hanadb_memory_service_stack_size_mb	Size of the stack used by the service	mb
	sap_hanadb_memory_service_compactors_freeable_size_mb	Memory that can be freed during a memory shortage per service in MB	mb
	sap_hanadb_memory_service_compactors_allocated_size_mb	Potential memory that can be released by the memory pool when the memory is insufficient for the service	mb
	sap_hanadb_memory_service_alloc_limit_mb	Maximum size of the memory pool for the service	mb
	sap_hanadb_memory_service_effective_alloc_limit_mb	Maximum valid memory pool size for the service (calculated by taking other processes into account)	mb
host_memory	sap_hanadb_host_memory_physical_total_mb	Total physical memory of the host	mb
	sap_hanadb_host_memory_resident_mb	Physical memory used by processes on a host	mb
	sap_hanadb_host_memory_physical_free_mb	Idle physical memory of a host	mb
	sap_hanadb_host_memory_swap_free_mb	Idle swap memory of the host	mb
	sap_hanadb_host_memory_swap_used_mb	Used swap memory of the host	mb
	sap_hanadb_host_memory_alloc_limit_mb	Maximum memory in MB that can be allocated to all processes on a host	mb
	sap_hanadb_host_memory_used_total_mb	Total memory size occupied by the SAP HANA process in the memory pool	mb
	sap_hanadb_host_memory_used_peak_mb	Maximum memory that can be occupied by the SAP HANA process in the memory pool after the instance is started	mb
	sap_hanadb_host_memory_pool_size_mb	Total memory pool size for the SAP HANA process	mb
	sap_hanadb_host_memory_code_size_mb	Total code snippet size of the SAP HANA process, including the dynamic link library	mb
	sap_hanadb_host_memory_shared_alloc_mb	Total shared memory size of the SAP HANA process	mb
sql_service	sap_hanadb_sql_service_executions_count	Total number of execution times of different types of SQL statements	count
	sap_hanadb_sql_service_elapsed_time_ms	Total execution time of different types of SQL statements	ms
	sap_hanadb_sql_service_elap_per_exec_avg_ms	Average execution time of different types of SQL statements	ms
	sap_hanadb_sql_service_lock_per_exec_ms	Average lock wait time for executing different types of SQL statements	ms
	sap_hanadb_sql_service_max_ela_time_ms	Maximum time required for executing different types of SQL statements	ms
sql_top_time	sap_hanadb_sql_top_time_consumers_execution_time_mu	Top 10 SQL statements with the longest execution duration	mu
sql_top_time	sap_hanadb_sql_top_time_consumers_execution_count	Total number of execution times of top 10 SQL statements with the longest execution duration	count
sql_top_mem	sap_hanadb_sql_top_mem_consumers_total_execution_memory_size_byte	Top 10 SQL statements with the largest memory usage	byte
sql_top_mem	sap_hanadb_sql_top_mem_consumers_execution_count	Total number of execution times of top 10 SQL statements with the largest memory usage	count
connections_total	sap_hanadb_connections_total_count	Total number of connections of different types	count
table_cs_top_mem	sap_hanadb_table_cs_top_mem_total_mb	Top 10 database tables with the largest memory usage	mb
	sap_hanadb_table_cs_top_mem_estimated_max_mb	Estimated maximum memory usage for the top 10 database tables with the largest memory usage	mb
	sap_hanadb_table_cs_top_mem_record_count	Number of data rows in the top 10 database tables with the largest memory usage	count
	sap_hanadb_table_cs_top_mem_disk_size_mb	Disk usage of the top 10 database tables with largest memory usage	mb
alerts	sap_hanadb_alerts_current_rating	Database alarm	rating

**Table 2** SAP NetWeaver ABAP and SAP NetWeaver Java application metrics
Metric Group	Metric Name	Description	Unit
application_version	sap_netweaver_application_version_info	Application version
instance_quantity	sap_netweaver_instance_quantity_count	Total number of instances in the application system	count
instance_quantity	sap_netweaver_active_instance_quantity_count	Number of active instances in the application system	count
application_ha_active	sap_netweaver_application_ha_active_status	Application HA status	status
abap_short_dumps	sap_netweaver_abap_short_dumps_count	Number of ABAP Dumps in the last one hour	count
abap_short_dumps_5m	sap_netweaver_abap_short_dumps_5m_count	Number of ABAP Dumps in the last five minutes	count
jobs	sap_netweaver_canceled_jobs_count	Number of jobs deleted (canceled) in the last one hour	count
jobs	sap_netweaver_finished_jobs_count	Number of jobs completed in the last one hour	count
logged_in_users	sap_netweaver_logged_in_users_count	Number of users who have logged in to the SAP application	count
lock_entries_usage	sap_netweaver_lock_entries_usage_percent	Lock entries usage	percent
extended_memory_utilization	sap_netweaver_extended_memory_utilization_percent	Extended memory usage (%)	percent
heap_memory_utilization	sap_netweaver_heap_memory_utilization_percent	Heap memory usage (%)	percent
dialog_response_time	sap_netweaver_dialog_response_time_ms	Dialog response duration	ms
dialog_db_request_time	sap_netweaver_dialog_db_request_time_ms	Time required for processing a request from Dialog to the database	ms
work_processes	sap_netweaver_work_processes_utilization_percent	Process usage (%). The types of processes are dialog, background, spool, update 1, and update 2.	percent
	sap_netweaver_number_of_total_work_processes_count	Total number of processes. The types of processes are dialog, background, spool, update 1, and update 2.	count
	sap_netweaver_number_of_free_work_processes_count	Number of idle processes. The types of processes are dialog, background, spool, update 1, and update 2.	count
jobs	sap_netweaver_running_jobs_count	Number of running jobs	count
failed_idocs	sap_netweaver_failed_idocs_count	Number of failed Intermediate Documents (IDocs)	count
update_records	sap_netweaver_update_records_count	Number of update records in the last one minute	count
update_records	sap_netweaver_failed_updates_count	Number of failed update records in the last one minute	count
rfc_ping	sap_netweaver_rfc_ping_ms	RFC ping latency from each instance to the PAS node	ms
j2ee_running_process	sap_netweaver_j2ee_running_process_count	Number of running Java processes	count
j2ee_thread	sap_netweaver_j2ee_thread_count	Number of Java threads	count
j2ee_session	sap_netweaver_j2ee_session_count	Number of Java sessions	count
j2ee_websession	sap_netweaver_j2ee_websession_count	Number of Java web sessions	count
j2ee_ejbsession	sap_netweaver_j2ee_ejbsession_count	Number of Java EJB sessions	count
j2ee_vm_heap_size	sap_netweaver_j2eevmheap_size_mb	Size of the local classes or local objects heap in the Java process	mb
	sap_netweaver_j2eevmheap_commitSize_mb	Commit size of the local classes or local objects heap in the Java process	mb
	sap_netweaver_j2eevmheap_maxUsedSize_mb	Maximum used size of the local classes or local objects heap in the Java process	mb
	sap_netweaver_j2eevmheap_initialSize_mb	Initial size of the local classes or local objects heap in the Java process	mb
	sap_netweaver_j2eevmheap_maxSize_mb	Maximum size of the local classes or local objects heap in the Java process	mb