Saphana Receiver

Available in: contrib Maintainers: @dehaansa Source: opentelemetry-collector-contrib

Supported Telemetry

Overview

Prerequisites

The receiver is intended to support SAP HANA version 2, older versions have not been tested.

A monitoring user requires SELECT access to the relevant monitoring views. The following sql script should create a monitoring role and apply it to a monitoring user if executed by a user with sufficient permissions connected to the SAP HANA instance.

--Create the user
CREATE RESTRICTED USER otel_monitoring_user PASSWORD <password>;

--Enable user login
ALTER USER otel_monitoring_user ENABLE CLIENT CONNECT;

--Create the monitoring role
CREATE ROLE OTEL_MONITORING;

--Grant permissions to the relevant views
GRANT CATALOG READ TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_BACKUP_CATALOG TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_BLOCKED_TRANSACTIONS TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_CONNECTIONS TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_CS_ALL_COLUMNS TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_CS_TABLES TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_DATABASE TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_DISKS TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_HOST_RESOURCE_UTILIZATION TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_LICENSES TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_RS_TABLES TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_SERVICE_COMPONENT_MEMORY TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_SERVICE_MEMORY TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_SERVICE_REPLICATION TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_SERVICE_STATISTICS TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_SERVICE_THREADS TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_SERVICES TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_VOLUME_IO_TOTAL_STATISTICS TO OTEL_MONITORING;
GRANT SELECT ON SYS.M_WORKLOAD TO OTEL_MONITORING;
GRANT SELECT ON _SYS_STATISTICS.STATISTICS_CURRENT_ALERTS TO OTEL_MONITORING;

--Add the OTEL_MONITOR role to the monitoring user
GRANT OTEL_MONITORING TO otel_monitoring_user;

Configuration

The following settings are required:

endpoint (default: localhost:33015): The hostname/IP address and port of the SAP HANA instance
username
password

The following settings are optional:

collection_interval (default = 60s): This receiver runs on an interval. Each time it runs, it queries memcached, creates metrics, and sends them to the next consumer. The collection_interval configuration option tells this receiver the duration between runs. This value must be a string readable by Golang’s ParseDuration function (example: 1h30m). Valid time units are ns, us (or µs), ms, s, m, h.
initial_delay (default = 1s): defines how long this receiver waits before starting.
tls:
- insecure (default = true): whether to disable client transport security for the exporter’s connection.
- ca_file: path to the CA cert. For a client this verifies the server certificate. Should only be used if insecure is set to false.
- cert_file: path to the TLS cert to use for TLS required connections. Should only be used if insecure is set to false.
- key_file: path to the TLS key to use for TLS required connections. Should only be used if insecure is set to false.

Example:

receivers:
  saphana:
    endpoint: "localhost:33015"
    collection_interval: 60s
    metrics:
      saphana.cpu.used:
        enabled: false

The full list of settings exposed for this receiver are documented in config.go with detailed sample configurations in testdata/config.yaml.

Metrics

Details about the metrics produced by this receiver can be found in metadata.yaml. Further details of the monitoring queries used to collect them may be found in queries.go.

If all of the metrics collected by a given monitoring query are marked as enabled: false in the receiver configuration, the monitoring query will not be executed.

Metrics

Metric Name	Description	Unit	Type	Attributes
✅ `saphana.alert.count`	Number of current alerts.	{alerts}	UpDownCounter	alert_rating
✅ `saphana.backup.latest`	The age of the latest backup by start time.	s	Gauge
✅ `saphana.column.memory.used`	The memory used in all columns.	By	UpDownCounter	column_memory_type, column_memory_subtype
✅ `saphana.component.memory.used`	The memory used in components.	By	UpDownCounter	component
✅ `saphana.connection.count`	The number of current connections.	{connections}	UpDownCounter	connection_status
✅ `saphana.cpu.used`	Total CPU time spent.	ms	Counter	cpu_type
✅ `saphana.disk.size.current`	The disk size.	By	UpDownCounter	path, disk_usage_type, disk_state_used_free
✅ `saphana.host.memory.current`	The amount of physical memory on the host.	By	UpDownCounter	memory_state_used_free
✅ `saphana.host.swap.current`	The amount of swap space on the host.	By	UpDownCounter	host_swap_state
✅ `saphana.instance.code_size`	The instance code size, including shared libraries of SAP HANA processes.	By	UpDownCounter
✅ `saphana.instance.memory.current`	The size of the memory pool for all SAP HANA processes.	By	UpDownCounter	memory_state_used_free
✅ `saphana.instance.memory.shared.allocated`	The shared memory size of SAP HANA processes.	By	UpDownCounter
✅ `saphana.instance.memory.used.peak`	The peak memory from the memory pool used by SAP HANA processes since the instance started (this is a sample-based value).	By	UpDownCounter
✅ `saphana.license.expiration.time`	The amount of time remaining before license expiration.	s	Gauge	system, product
✅ `saphana.license.limit`	The allowed product usage as specified by the license (for example, main memory).	{licenses}	UpDownCounter	system, product
✅ `saphana.license.peak`	The peak product usage value during last 13 months, measured periodically.	{licenses}	UpDownCounter	system, product
✅ `saphana.network.request.average_time`	The average response time calculated over recent requests	ms	Gauge
✅ `saphana.network.request.count`	The number of active and pending service requests.	{requests}	UpDownCounter	active_pending_request_state
✅ `saphana.network.request.finished.count`	The number of service requests that have completed.	{requests}	Counter	internal_external_request_type
✅ `saphana.replication.average_time`	The average amount of time consumed replicating a log.	us	Gauge	primary_host, secondary_host, port, replication_mode
✅ `saphana.replication.backlog.size`	The current replication backlog size.	By	UpDownCounter	primary_host, secondary_host, port, replication_mode
✅ `saphana.replication.backlog.time`	The current replication backlog.	us	UpDownCounter	primary_host, secondary_host, port, replication_mode
✅ `saphana.row_store.memory.used`	The used memory for all row tables.	By	UpDownCounter	row_memory_type
✅ `saphana.schema.memory.used.current`	The memory size for all tables in schema.	By	UpDownCounter	schema, schema_memory_type
✅ `saphana.schema.memory.used.max`	The estimated maximum memory consumption for all fully loaded tables in schema (data for open transactions is not included).	By	UpDownCounter	schema
✅ `saphana.schema.operation.count`	The number of operations done on all tables in schema.	{operations}	Counter	schema, schema_operation_type
✅ `saphana.schema.record.compressed.count`	The number of entries in main during the last optimize compression run for all tables in schema.	{records}	UpDownCounter	schema
✅ `saphana.schema.record.count`	The number of records for all tables in schema.	{records}	UpDownCounter	schema, schema_record_type
✅ `saphana.service.code_size`	The service code size, including shared libraries.	By	UpDownCounter	service
✅ `saphana.service.count`	The number of services in a given status.	{services}	UpDownCounter	service_status
✅ `saphana.service.memory.compactors.allocated`	The part of the memory pool that can potentially (if unpinned) be freed during a memory shortage.	By	UpDownCounter	service
✅ `saphana.service.memory.compactors.freeable`	The memory that can be freed during a memory shortage.	By	UpDownCounter	service
✅ `saphana.service.memory.effective_limit`	The effective maximum memory pool size, calculated considering the pool sizes of other processes.	By	UpDownCounter	service
✅ `saphana.service.memory.heap.current`	The size of the heap portion of the memory pool.	By	UpDownCounter	service, memory_state_used_free
✅ `saphana.service.memory.limit`	The configured maximum memory pool size.	By	UpDownCounter	service
✅ `saphana.service.memory.shared.current`	The size of the shared portion of the memory pool.	By	UpDownCounter	service, memory_state_used_free
✅ `saphana.service.memory.used`	The used memory from the operating system perspective.	By	UpDownCounter	service, service_memory_used_type
✅ `saphana.service.stack_size`	The service stack size.	By	UpDownCounter	service
✅ `saphana.service.thread.count`	The number of service threads in a given status.	{threads}	UpDownCounter	thread_status
✅ `saphana.transaction.blocked`	The number of transactions waiting for a lock.	{transactions}	UpDownCounter
✅ `saphana.transaction.count`	The number of transactions.	{transactions}	Counter	transaction_type
✅ `saphana.uptime`	The uptime of the database.	s	UpDownCounter	system, database
✅ `saphana.volume.operation.count`	The number of operations executed.	{operations}	Counter	path, disk_usage_type, volume_operation_type
✅ `saphana.volume.operation.size`	The size of operations executed.	By	Counter	path, disk_usage_type, volume_operation_type
✅ `saphana.volume.operation.time`	The time spent executing operations.	ms	Counter	path, disk_usage_type, volume_operation_type

Attributes

Attribute Name	Description	Type	Values
`state`	The state of network request.	string	`active`, `pending`
`rating`	The alert rating.	string
`subtype`	The subtype of column store memory.	string	`data`, `dict`, `index`, `misc`
`type`	The type of column store memory.	string	`main`, `delta`
`component`	The SAP HANA component.	string
`status`	The connection status.	string	`running`, `idle`, `queueing`
`type`	The type of cpu.	string	`user`, `system`, `io_wait`, `idle`
`database`	The SAP HANA database.	string
`state`	The state of the disk storage.	string	`used`, `free`
`usage_type`	The SAP HANA disk & volume usage type.	string
`state`	The state of swap data.	string	`used`, `free`
`type`	The type of network request.	string	`internal`, `external`
`state`	The state of memory.	string	`used`, `free`
`path`	The SAP HANA disk path.	string
`port`	The SAP HANA port.	string
`primary`	The primary SAP HANA host in replication.	string
`product`	The SAP HANA product.	string
`mode`	The replication mode.	string
`type`	The type of row store memory.	string	`fixed`, `variable`
`schema`	The SAP HANA schema.	string
`type`	The type of schema memory.	string	`main`, `delta`, `history_main`, `history_delta`
`type`	The type of operation.	string	`read`, `write`, `merge`
`type`	The type of schema record.	string	`main`, `delta`, `history_main`, `history_delta`
`secondary`	The secondary SAP HANA host in replication.	string
`service`	The SAP HANA service.	string
`type`	The type of service memory.	string	`logical`, `physical`
`status`	The status of services.	string	`active`, `inactive`
`system`	The SAP HANA system.	string
`status`	The status of threads.	string	`active`, `inactive`
`type`	The transaction type.	string	`update`, `commit`, `rollback`
`type`	The type of operation.	string	`read`, `write`

Resource Attributes

Attribute Name	Description	Type	Enabled
`db.system`	The type of database system.	string	✅
`saphana.host`	The SAP HANA host.	string	✅

Configuration

Example Configuration

saphana:
  metrics:
    saphana.cpu.used:
      enabled: false
  endpoint: example.com:30015
  username: otel
  password: password
  collection_interval: 2m

Last generated: 2026-10-05

​Saphana Receiver

​Supported Telemetry

​Overview

​Prerequisites

​Configuration

​Metrics

​Metrics

​Attributes

​Resource Attributes

​Configuration

​Example Configuration

Saphana Receiver

Supported Telemetry

Overview

Prerequisites

Configuration

Metrics

Metrics

Attributes

Resource Attributes

Configuration

Example Configuration