September 27, 2023 at 6:40 pm
Hi
I am new to replication and we have database of size around 2TB and its has been set up for replication .there are 4 subscriber to it. Tables(articles) of database has been divided into 14 publishers. Issue sometime we face high latency on server with lakhs of undistributed command
so what should i check. I mean i want to check from which tables(articles) highest number of commands pending from publisher to distributor and from distributor to subscriber .where to check i mean which system tables or stored procedures to check.
As i found replication monitor to be insufficient.
I know its tea spoon feeding but as i am new to sql server replication
regards
Anoop
September 28, 2023 at 7:14 am
Monitoring and troubleshooting replication in SQL Server, especially in a large environment like yours with multiple subscribers and a 2TB database, can be challenging. You can check this blog to repair transaction replication issues.
https://www.stellarinfo.com/blog/how-to-troubleshoot-sql-server-transactional-replication-issues/
I hope this will help you to resolve issue!!
October 8, 2023 at 10:53 am
Monitoring and troubleshooting replication in SQL Server, especially in a large environment like yours with multiple subscribers and a 2TB database, can be challenging. You can check this blog to repair transaction replication issues.
https://www.stellarinfo.com/blog/how-to-troubleshoot-sql-server-transactional-replication-issues/
I hope this will help you to resolve issue!!
Hi thanks for link but any other hep link regarding latency troubleshoot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply