Mssql Replication(step 4)

Bước VI. Giám sát việc xuất bản và đăng ký phần này của bài viết mô tả làm thế nào để sử dụng Replication Monitor theo dõi việc xuất bản và đăng ký bạn tạo ra. 1. Trong SQL Server Management Studio, mở rộng Replication. 2. Mở rộng các ấn phẩm địa phương. 3. Nhấp chuột phải vào thư mục các ấn phẩm địa phương và sau đó nhấp vào Launch Replication Monitor. Click vào đây để xem ảnh nhỏ. | Step VI. Monitoring the Publication and Subscription This section of the article describes how to use Replication Monitor to monitor the publication and subscription you created. 1. In SQL Server Management Studio expand Replication. 2. Expand Local Publications. 3. Right-click the Local Publications folder and then click Launch Replication Monitor. Click this bar to view the small image. Figure 56. Starting Replication Monitor Subscription status is displayed on the All Subscriptions tab in the right pane. The time it took for data to replicate from the Oracle Publisher to the Subscriber is listed in the Latency column and a relative rating of this performance is listed in the Performance column. Because initial snapshots take more time to generate and deliver than incremental changes the initial latency is typically much greater than the latency for incremental changes. Click this bar to view the small image. Figure 57. Viewing subscription status in Replication Monitor 4. Latency between the Publisher and Subscriber is calculated by measuring two intervals in replication processing a. The time that is required from when a change is made at the Publisher until the Log Reader Agent delivers the change to the distribution database. b. The time that is required for the Distribution Agent to deliver the change from the distribution database to the subscription database. 5. To view the details of the replication processing involved in these steps you can double-click the subscription row in the right pane. The Distributor To Subscriber History tab shows the history for the selected Distribution Agent. Click this bar to view the small image. Figure 58. Viewing Distribution Agent history Publisher To Distributor History tab displays the history for the Log Reader Agent. Click this bar to view the small .