MS SQL Basics Tutorial: Replication Monitor

Replication is the most powerful and complex component in SQL Server, so it is unavoidable to replicate errors in specific applications. But, thankfully, SQL Server provides replication management tools-Replication Monitor to help DBAs find out why replication errors occur. With Replication Monitor you can:

Browse all Publishers ' publications and subscriptions supported by the distributor;

Browse the status information and history of the replication agent;

Monitor replication alerts related to replication transactions.

You can also use Replication Monitor to monitor the Snapshot Agent, the log reading agent, the Distribution Agent, and the Merge Agent.

Note: The replication pro can be activated only if the server plays the Distributor role and the current user has the sysadmin role.

If you are ready to monitor the activity status of the Snapshot Agent, follow these steps;

(1) Start SQL Server Enterprise Manager, log on to the specified server, turn on Replication Monitor, Agents folder sequentially.

(2) When snapshot Agents is selected, the Snapshot Agent that has been created is displayed in the right pane.

(3) Right-click the agent ready to view, select the agent History option in the pop-up menu, and open the Snapshot Agent History dialog box, as shown in Figure 16-57;

(4) Click the Sessions Details button to open the session details of Snapshot Agents dialog box, as shown in Figure 16-58. In this dialog box, you can find out what the Snapshot Agent has done so far, and how long it has been running.

Summary of this chapter

This chapter focuses on the most important built-in components of SQL Server-replication content involves basic concepts of replication, terminology, replication topologies, and detailed information on how snapshot replication, transactional replication, merge replication works, and where appropriate. It also describes how to configure replication and create a publication. Finally, let the reader understand the exciting features that Replication Monitor displays in locating replication errors and viewing replication information.

See the full set of "MS SQL Basics Tutorials"