PowerConnect for SAP Solutions
Breadcrumbs

PowerConnect for SAP HANA DB Agent Configuration

Configuration Steps

  • The agent is configured using a properties file located in the PowerConnect installation directory under the conf folder e.g.

/opt/powerconnect/conf/powerconnect-hana-db.properties

An example configuration file is show below which enables os metrics and audit log collection:

license_key="XXX-XXX-XXX-XXX"
cpu_monitoring_enabled="true"
memory_monitoring_enabled="true"
disk_space_monitoring_enabled="true"
audit_log_db_system_monitoring_enabled="true"
db_system_host="localhost"
db_system_port="35015"
db_system_user="powerconnect"
db_system_password="mysecretpassword"
splunk_hec_url="http://1.1.1.1:8088"
splunk_hec_key="123-456-789-1011-1213"
splunk_index="sap"

Configuration Options

Configuration

Description

Required

Default Value

Comments

license_key

License key for the agent

True


 

db_system_host

Hostname of SAP HANA DB

False

localhost

Agent by default connects to SAP HANA DB running on the localhost

db_system_port

Port of SAP HANA DB

False

30015


db_system_user

Username used to connect to SAP HANA DB

Only for audit log collection



db_system_password

Password for user to connect to SAP HANA DB

Only for audit log collection



cpu_monitoring_enabled

Enable operating system CPU monitoring


false


cpu_monitoring_interval

How often to collect CPU metrics (ms)


60000


memory_monitoring_enabled

Enable operating system memory monitoring


false


memory_monitoring_interval

How often to collect memory metrics (ms)


60000


os_process_monitoring_enabled

Enable operating system process monitoring


false


os_process_monitoring_interval

How often to collect process metrics (ms)


60000


disk_monitoring_enabled

Enable disk iops monitoring


false


disk_monitoring_interval

How often to collect disk iops metrics (ms)


60000


disk_space_monitoring_enabled

Enable disk space monitoring


false


disk_space_monitoring_interval

How often to collect disk space metrics (ms)


60000


network_monitoring_enabled

Enable network interface monitoring

False

false


network_monitoring_interval

How often to collect network interface metrics (ms)

False

60000


oom_trace_monitoring_enabled

Enable SAP HANA out of memory trace file monitoring

False

false


oom_trace_monitoring_directory

Directory where out of memory trace files are generated

False

$retrieval-path$/trace


oom_trace_monitoring_filefilter

File pattern to match for oom trace files

False

compileserver_.*\\.oom\\.trc


audit_log_db_system_monitoring_enabled

Enable audit log collection for system database

False

false


audit_log_db_system_monitoring_interval

How often to collect audit log data (ms)

False

60000


audit_log_db_system_monitoring_lag

Lag setting for audit log collection (ms)

False

60000

This setting is to deal with scenarios where there is a lag between the data being written to the database and its availability for query (usually high load)

audit_log_db_system_monitoring_table

Audit log table name

False

ALL_AUDIT_LOG