high latency in sql server transactional replication

• anoop.mig29

  SSCrazy

  Points: 2229

  More actions

  September 27, 2023 at 6:40 pm

  #4296393

  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

• Priyanka Chouhan

  SSC Rookie

  Points: 36

  More actions

  September 28, 2023 at 7:14 am

  #4296731

  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!!

• anoop.mig29

  SSCrazy

  Points: 2229

  More actions

  October 8, 2023 at 10:53 am

  #4303819

  Priyanka Chouhan wrote:

  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