HANA replication shipping statistics

Log shipping statistics is important in the replication mechanism as it defines the capacity of the primary
system to send changes toward the secondary system. If logs are produced quicker than sent 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

To monitor log shipping statistics, create a rule in the table.

You can customize the monitoring for a given node or service by using the host and service filter.

Shipping statistics

Each metric can be monitored separately and will generate an alert if threshold is reached.

Set a 0 value if you don't want to set a threshold.

Surveillance table

Parameter	Description
Active	To enable/disable a rule
Host	A filter on the host name.
Service	A filter on the service
Max log shipping delay	The maximum time between replicated Log position on secondary and currentposition in primary
Max log shipping size	The maximum size of log segments waiting to be shipped to secondary.
Max last delta replica size	The maximum size of delta data segments waiting to be shipped to secondary.
Max last delta replica duration	The maximum transfer duration of delta data segments.
Default severity	The alarm severity to use for any threshold breach, if the advanced threshold syntax is not used.
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_SHIPPING_DELAY	Seconds	SITE/HOST/PORT	Sends the log shipping delay
REPLICATION_LOG_SHIPPING_SIZE	Megabytes	SITE/HOST/PORT	Sends the log shipping size
REPLICATION_LAST_DELTA_REPLICA_SIZE	Megabytes	SITE/HOST/PORT	Sends the last replica size
REPLICATION_LAST_DELTA_REPLICA_DURATION	Seconds	SITE/HOST/PORT	Sends the duration of the last delta replication