/
PowerConnect for SAP HANA DB Agent Configuration

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

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

 

 

Related content

Configuring Splunk Connection in PowerConnect for SAP HANA DB
Configuring Splunk Connection in PowerConnect for SAP HANA DB
More like this
PowerConnect for SAP HANA DB Outbound Connection Configuration
PowerConnect for SAP HANA DB Outbound Connection Configuration
Read with this
PowerConnect for SAP HANA DB Agent Installation
PowerConnect for SAP HANA DB Agent Installation
More like this
PowerConnect for SAP HANA DB
PowerConnect for SAP HANA DB
Read with this
PowerConnect ABAP Installation Guide (PowerConnect ABAP 7.X)
PowerConnect ABAP Installation Guide (PowerConnect ABAP 7.X)
More like this
PowerConnect ABAP Installation Guide (PowerConnect ABAP 8.X)
PowerConnect ABAP Installation Guide (PowerConnect ABAP 8.X)
More like this