Viewing Monitoring Metrics

database_version

sap_hanadb_database_version_info

Database version

service_quantity

sap_hanadb_service_quantity_count

Total number of instance processes

count

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

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

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

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

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

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

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

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