HANA replication LOG retention statistics

Purpose

Log retention is important in the replication mechanism as it defines the capacity of the primary system to absorb and store changes waiting to be sent toward the secondary system. If logs are produced quicker than consumed for a long time, the replication will be compromised. This monitor will detect those situations and send alarms so you can react before replication stops.

Configuration hints

Create new rule in the table. You can customize the filter in order to define a specific configuration for a given service or host.

Minimum retention time The minimum time expected before reaching the retention limit parameter settings. Send an alarm if below threshold

Minimum time before disk full The minimum time expected before a disk full situation. Send alarm if below threshold

Max LOG backup avg. daily size The maximum average size of generated log backup on a daily basis, computed over a configurable period. Send an alarm if the average size is over a limit. This is an indicator of a growing number of changes to replicate.

Atomic fields

Nb of days for computing average period	Defines the period to compute average backup size

Surveillance table

Parameter	Description
Active	To enable/disable a rule
Host	A filter on the host
Service	A filter on the service
Minimum log retention time	The minimum time expected before reaching the retention limitparameter settings.
Minimum time before disk full	The minimum time expected before a disk full situation
Maximum average log size per day	The maximum average size of generated log backup on a daily basis
Severity	The severity of the generated alert.
Auto clear	If checked, the alarm will be cleared as soon as the alarm condition is not met anymore
Alarm tag	This field allows to add custom text within the alarm message. %MSG% variable will containthe actual generated message and can be used such as: “my_prefix %MSG% my_suffix”. By default, tagwill be used as prefix.
enable Alarm	To enable alarm sending
enable QOS	To enable metric sending

Generated metrics

metricId	metricUnit	metricTarget	metricDescription
REPLICATION_LOG_RETENTION_REMAINING_DAYS	Days	HOST:PORT	Sends the remaining days before reaching retention limit
REPLICATION_LOG_BACKUP_DISK_FULL_REMAINING_DAYS	Days	HOST:PORT	Sends the remaining days before LOG disk full
REPLICATION_LOG_BACKUP_DAILY_AVG_SIZE	Megabytes	HOST:PORT	Sends average size of daily LOG backup