Replication Monitor

The Replication Monitor tab provides current status information for all replications defined in the metadata that is selected in the Metadata Explorer.

Select a replication in the Replication Monitor tab to view some of its properties in the Properties pane. To view all replication properties, select the replication and, from the right mouse button menu, choose Replication Properties to open the Replication Properties dialog.

Show Summary	Display/hide the summary panel at the bottom of the Replication Monitor to see counts of replications with different status, as well as information about the maximum and average values for transaction latency for replications at any given time.
Show Replication History	Display the history for a selected replication.
Clear Replication Status	Clear status information for selected replication(s).

Further information is available for:

Replication Status Column
Initialization Status Column
Last Replication Status Column
History Status Column
Latency Status Column

Replication Status Column

The Replication Status column displays one of the following values:

Idle	The replication is active, or enabled, and ready to run but is not currently running.
Disabled	The replication is disabled. To enable or disable a replication, select the replication and use the right mouse button menu. When a replication is disabled, it cannot run. You must enable the replication so that it can be added to the Replication Agent task list.
Refreshing	The replication is currently running. A refresh operation is being performed.
Mirroring	The replication is currently running. A mirroring operation is being performed.

Initialization Status Column

The Initialization Status column is used to display and manage the status of an Initial Refresh replication. It contains one of the following values.

--	Uninitialized -- a Refresh operation has never run.
Requesting	A Refresh request has been submitted, but the Replication Agent is not running, so the request cannot be proccessed.
Pending	A Refresh request has been submitted to the Replication Agent but the refresh operation has not completed.
Executed	A Refresh operation has successfully been executed

When creating a replication in the Replication wizard, it is possible to set an Initial Refresh where all selected data is copied from the source table(s) to the target table(s) prior to running the regular replication schedule. In the Scheduling screen, check the Execute Initial Refresh option.

To change the initialization status of a replication, right click on it and select ‘Run Initial Refresh’. If the Replication Agent is not running, the status changes immediately, putting the replication into a temporary mode (“Requesting…”) until the Replication Agent accepts the request. When the Replication Agent is running, once it has accepted the initialization request, the Initialization Status changes to Pending. The operation can also be performed on disabled replications, where the Refresh operation is executed once the Replication Agent is started and the replication enabled. A Pending status can be removed by selecting the replication and the same Run Initial Refresh menu item.

NOTE: It is possible to set the Run Initial Refresh option for an individual replication within a group, or for a whole group. To set Run Initial Refresh for a replication within a group, select the replication in the Replication Monitor and choose Run Initial Refresh from the right mouse button menu. To set Run Initial Refresh for a group, in the Metadata Explorer, select the group and choose Run Initial Refresh from the right mouse button menu.

Last Replication Status Column

The Last Replication Status column can provide information about specific events that have recently occurred.

Success (0)	The replication was executed with no errors.
Warning (1)	The replication was executed through the end but some errors or warning were generated.
Errors (2)	The replication was stopped by the replication engine for some major problem. Check the Log for more information about the error.
Aborted (3)	Not currently implemented.
Stopped (4)	The replication was stopped by the user.

History Status Column

The History Status column provides error information for both the most recent replication and for prior replications. When a replication error is flagged, select the replication and, from the right mouse button menu, choose Show History to open the History Viewer and explore the error(s). Note that, to record a replication status history, you need to set the Activate Log History option in the Log tab of the Replication Agent Options dialog.

	Replication(s) completed successfully without errors.
	One or more errors occurred during the replication(s). Select the replication and, from the right mouse button menu, choose Show History to open the History Viewer and explore the error(s).
	The replication status reported by the History flag has been cleared. If the History Status column initially showed an error flag and you have examined the error, you can change the flag to show that the error has been investigated. Select the replication and, from the right mouse button menu, choose Clear History to display this flag.

Validation Result

The result of applying the most recent replication validation.

Last Verifier Status

The result of applying the most recent verification of replication results.

Latency Status Column

The Latency Status column provides information on the current status of the replication. It reports a warning when the latency period between the current time and the latest processed transaction time (or the last scheduled mirroring time if there are no transactions) exceeds the Transaction Latency Threshold value in the Options dialog. When you see a warning in this column, open the Replication Activity tab by selecting the replication, then choosing Show Replication Activity from the right mouse button menu.

Transaction Latency Column

Displays the latency period between the current time and the latest processed transaction time (or the last scheduled mirroring time if there are no transactions.)

Opening the Replication Monitor

In the Management Center toolbar, select Replication Monitor.