Replication monitors display the availability and critical performance statistics of a particular component in the replication environment.
The replication monitors provide the status of Replication Servers, Replication Agents, and replication paths. Each monitor also provides a Quick Admin view to allow you to control the flow of data and configure replication parameters, a list of replication paths, and a status bar for each view.
The Replication Server Monitor includes these views:
-
Overview – displays high-level information, such as the server name, version, and its status. It also displays the memory usage graph, and a bar chart for partitions and the Top 10 queues by size.
- Paths – displays a table of Replication Server paths, including
their state, activity, latency, and latency monitoring status information. It
also displays the latency history chart of a Replication Server.
-
Connections – displays the information for Replication Server connections, which include the name, Replication Agent (RA) status, and Data Server Interface (DSI) status. It also shows these graphs for the selected connection:
- DSI Activity and Stable Queue Transaction (SQT)
Cache
- Transactions Removed from SQT
- Transaction Activity
- Transaction Success Rate
- Group and Batch Size
-
Logical Connections – displays the Replication Server logical connection information in a warm-standby environment.
- Routes – displays the Replication Server route information,
which includes the name, route status, and the route's activity graph. The name
of a dedicated route is displayed with its corresponding primary connection
enclosed in parenthesis.
- Queues – displays Replication Server queues information, which
includes the name and type. The name of a dedicated route queue is displayed
with its corresponding primary connection enclosed in parenthesis. It also shows
these graphs for the selected queue :
- Queue Reads and Writes
- Queue Bytes and Queue Cache
- SQT cache (only for inbound queues)
- Backlog
- Duplicates Detected
- Transactions Removed from SQT (only for inbound
queues)
- Distributor activity (only for inbound queues)
The Replication Agent Monitor includes this view:
-
Overview – displays high-level information, which includes the status, name, version number of the server, primary connection, primary host, Replication Server connection, and the information on when it was last started. It displays a list of paths, which you can click to open a path dashboard. It also displays these graphs:
- Java Virtual Machine (JVM) Memory Usage
- LTI Activity and Queue Sizes
- Log Reader Activity, Queue sizes, and Scan Buffer
The Adaptive Server Replication Agent Thread Monitor has this view:
- Overview – displays high-level information, such as the name,
status, and controlling Replication Servers for multiple RepAgent thread
connections. It also displays the log and activity details in a graph
format.
The Replication Path Dashboard has this view:
- Overview – displays a detailed information of a particular
path, which includes its primary and replicate connection, status, data loss
detection result, and these graphs:
- Adaptive Server RepAgent thread commands sent per
second
- Inbound queue activity for the primary database
- Outbound queue activity for the replicate database
- Database Server Interface (DSI) Commands per Second
- Latency
- Latency History
- Dedicated routes (if any)