products:promonitor:6.7:monitorsguide:hana:hanareplicationshippingstatistics

HANA replication shipping statistics

Purpose

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

ParameterDescription
ActiveTo enable/disable a rule
HostA filter on the host name.
ServiceA filter on the service
Max log shipping delayThe maximum time between replicated Log position on secondary and currentposition in primary
Max log shipping sizeThe maximum size of log segments waiting to be shipped to secondary.
Max last delta replica sizeThe maximum size of delta data segments waiting to be shipped to secondary.
Max last delta replica durationThe maximum transfer duration of delta data segments.
Default severityThe alarm severity to use for any threshold breach, if the advanced threshold syntax is not used.
Auto clearIf checked, the alarm will be cleared as soon as the alarm condition is not met anymore.
Alarm tagThis 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 AlarmTo enable alarm sending
enable QOSTo enable metric sending

Generated metrics

metricIdmetricUnitmetricTargetmetricDescription
REPLICATION_LOG_SHIPPING_DELAYSecondsSITE/HOST/PORTSends the log shipping delay
REPLICATION_LOG_SHIPPING_SIZEMegabytesSITE/HOST/PORTSends the log shipping size
REPLICATION_LAST_DELTA_REPLICA_SIZEMegabytesSITE/HOST/PORTSends the last replica size
REPLICATION_LAST_DELTA_REPLICA_DURATIONSecondsSITE/HOST/PORTSends the duration of the last delta replication
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.7/monitorsguide/hana/hanareplicationshippingstatistics.txt · Last modified: 2019/02/11 15:26 (external edit)