Discovery

This plugin can be integrated with Pandora FMS Discovery.

To do this, you must upload the ".disco" package, which can be downloaded from the Pandora FMS library:

https://pandorafms.com/library/

Once uploaded, SAP HANA environments can be monitored by creating Discovery tasks from the Management > Discovery > Applications section.

For each task, the following minimum parameters will be required:

• SAP HANA target string: IP address of the host running SAP HANA, port, and database instance.
• Credentials: Custom-type username and password. To use them, a new credential must be created in Management > Configuration > Credential store.

The task configuration can also be adjusted to customize the desired monitoring:

• Max threads: Maximum number of concurrent threads used to execute monitoring queries.
• Target agent: Allows manually defining the agent names where modules will be created. One agent name must be provided for each SAP HANA target string, preserving the same order. If left empty, the plugin will automatically create agents using the HOST - DATABASE format.
• Regexp to filter modules: Enables module filtering using regular expressions.
• Allow regexp: If filtering is enabled, only modules whose names match this regular expression will be created.
• Regexp to discard modules: Enables module exclusion using regular expressions.
• Deny regexp: If exclusion is enabled, modules whose names match this regular expression will not be created.
• Backups Size: Creates the module backups_estimated_size_bytes, containing the estimated SAP HANA backup size.
• Timestamp: Creates the module timestamp, containing the current database date/time to verify time drift.
• Hana Version: Creates the module version, containing the installed SAP HANA version.
• Data Disk Information: Creates the modules volumes_count and volumes_io_entries, with basic volume and I/O activity information.
• Hana Service Statistics: Creates modules for each detected SAP HANA service, including ACTIVE_STATUS, PROCESS_CPU_TIME, TOTAL_CPU_TIME, PROCESS_MEMORY, TOTAL_MEMORY, AVAILABLE_MEMORY, ACTIVE_REQUEST_COUNT, PENDING_REQUEST_COUNT, ACTIVE_THREAD_COUNT, THREAD_COUNT, OPEN_FILE_COUNT, REQUESTS_PER_SEC, RESPONSE_TIME, START_TIME, and SYS_TIMESTAMP.
• Hana CPU Time: Creates the modules cpu_total_time_ms, cpu_process_time_ms, and cpu_service_count, with aggregated CPU usage metrics across SAP HANA services.
• Hana RS Fragmentation: Creates the module rowstore_fragmentation_pct, with the estimated Row Store fragmentation percentage.
• Hana License: Creates the modules license_expiration_date, license_days_remaining, license_memory_limit, license_hardware_key, license_installation_number, license_product_name, license_system_id, license_swproductname, and license_enforced, with SAP HANA environment license information.
• Hana IO Stats: Creates the modules io_total_read_bytes, io_total_write_bytes, and io_total_time_ms, with aggregated read, write, and I/O timing metrics.
• Hana Get Stated Connections: Creates the modules connections_total, connections_running, connections_idle, connections_queued, connections_disconnected, and connections_unknown, with active connection status metrics.
• Hana Memory: Creates the modules memory_used_bytes and memory_allocation_limit_bytes, with memory usage and allocation limit metrics.
• Hana Transactions: Creates the modules blocked_transactions, blocked_transactions_distinct_users, and open_transactions, with information about open and blocked transactions.
• Execute custom queries: Enables execution of custom queries defined in the Custom queries field.
• Custom queries: Allows creating multiple custom modules using check_begin/check_end blocks.
• Custom module prefix: Defines a prefix that will be appended to generated module names.
• Custom modules (legacy): Allows defining custom modules using the legacy module:query:type:description format.

Examples of custom queries:

check_begin
name connections_total
description Total connections (SYS.M_CONNECTIONS)
operation value
target SELECT COUNT(*) FROM SYS.M_CONNECTIONS
datatype generic_data
unit conns
check_end

check_begin
name connections_active
description Active RUNNING connections (SYS.M_CONNECTIONS)
operation value
target SELECT COUNT(*) FROM SYS.M_CONNECTIONS WHERE CONNECTION_STATUS = 'RUNNING'
datatype generic_data
unit conns
check_end

check_begin
name memory_used_bytes
description Total used memory (INSTANCE_TOTAL_MEMORY_USED_SIZE)
operation value
target SELECT COALESCE(SUM(INSTANCE_TOTAL_MEMORY_USED_SIZE),0) FROM SYS.M_HOST_RESOURCE_UTILIZATION
datatype generic_data
unit bytes
check_end

check_begin
name memory_allocation_limit_bytes
description Memory allocation limit (ALLOCATION_LIMIT)
operation value
target SELECT COALESCE(SUM(ALLOCATION_LIMIT),0) FROM SYS.M_HOST_RESOURCE_UTILIZATION
datatype generic_data
unit bytes
check_end

check_begin
name cpu_total_time_ms
description Aggregated total CPU time (TOTAL_CPU_TIME)
operation value
target SELECT COALESCE(SUM(TOTAL_CPU_TIME),0) FROM SYS.M_SERVICE_STATISTICS
datatype generic_data
unit ms
check_end

check_begin
name cpu_process_time_ms
description Aggregated process CPU time (PROCESS_CPU_TIME)
operation value
target SELECT COALESCE(SUM(PROCESS_CPU_TIME),0) FROM SYS.M_SERVICE_STATISTICS
datatype generic_data
unit ms
check_end

check_begin
name service_total_memory_bytes
description Aggregated total service memory (TOTAL_MEMORY)
operation value
target SELECT COALESCE(SUM(TOTAL_MEMORY),0) FROM SYS.M_SERVICE_STATISTICS
datatype generic_data
unit bytes
check_end

check_begin
name service_available_memory_bytes
description Aggregated available memory (AVAILABLE_MEMORY)
operation value
target SELECT COALESCE(SUM(AVAILABLE_MEMORY),0) FROM SYS.M_SERVICE_STATISTICS
datatype generic_data
unit bytes
check_end

check_begin
name io_total_read_bytes
description Aggregated total bytes read (TOTAL_READ_SIZE)
operation value
target SELECT COALESCE(SUM(TOTAL_READ_SIZE),0) FROM SYS.M_VOLUME_IO_TOTAL_STATISTICS
datatype generic_data
unit bytes
check_end

check_begin
name io_total_write_bytes
description Aggregated total bytes written (TOTAL_WRITE_SIZE)
operation value
target SELECT COALESCE(SUM(TOTAL_WRITE_SIZE),0) FROM SYS.M_VOLUME_IO_TOTAL_STATISTICS
datatype generic_data
unit bytes
check_end

check_begin
name io_total_time_ms
description Aggregated total I/O time (TOTAL_IO_TIME)
operation value
target SELECT COALESCE(SUM(TOTAL_IO_TIME),0) FROM SYS.M_VOLUME_IO_TOTAL_STATISTICS
datatype generic_data
unit ms
check_end

check_begin
name rowstore_free_pct
description Row Store free percentage (FREE_SIZE/ALLOCATED_SIZE)
operation value
target SELECT CASE WHEN SUM(ALLOCATED_SIZE)=0 THEN 0 ELSE ROUND(SUM(FREE_SIZE)*100.0/SUM(ALLOCATED_SIZE),2) END FROM SYS.M_RS_MEMORY
datatype generic_data
unit %
min_warning 40
min_critical 20
inverse_warning 1
inverse_critical 1
check_end

check_begin
name hana_time_utc
description Database UTC timestamp
operation value
target SELECT TO_VARCHAR(CURRENT_UTCTIMESTAMP) FROM DUMMY
datatype generic_data_string
check_end

check_begin
name hana_services_running
description Number of active services (ACTIVE_STATUS='YES')
operation value
target SELECT COUNT(*) FROM SYS.M_SERVICE_STATISTICS WHERE ACTIVE_STATUS = 'YES'
datatype generic_data
unit services
check_end

Examples of legacy queries:

legacy_memory_used:SELECT COALESCE(SUM(INSTANCE_TOTAL_MEMORY_USED_SIZE),0) FROM SYS.M_HOST_RESOURCE_UTILIZATION:generic_data:Legacy memory usage
legacy_hana_version:SELECT VERSION FROM SYS.M_DATABASE:generic_data_string:Legacy HANA version