That's more then a broad, if not very vague question. Do you really expect a specific answer? One reason: Bad network infrastructure.
Reasons for replication latency over different data center and data domains
Issue is that on publisher, in replication monitor we are seeing replication is in sync, but our own monitoring which runs on the subscriber, reports that the column TIME in the table MSreplication_subscription is not updated and shows old value. How is this possible that on publisher replication is in sync and on subscriber it is not? What are some of the reasons for replication latency when working with different domains while same domain doesn't have any issue? Is there specific sp or commands or anything that we get alerts for latency issue happens and how to overcome this latency issues.
2 answers
Sort by: Most helpful
-
-
LiHongMSFT-4306 25,651 Reputation points
2024-01-30T07:54:42.8733333+00:00 Hi @Vanitha Dodla (MINDTREE LIMITED)
If you need to modify the default intra-site domain controller replication interval, please refer to this doc: How to Modify the Default Intra-Site Domain Controller Replication Interval.
Best regards,
Cosmog Hong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.