performance of replication

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  November 12, 2014 at 8:05 am

  #312896

  my replication performance is very slow , as the db is configured transactional replication . how can we trouble shoot the slowness of the replication and what tables do we need to check in distributor ?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 12, 2014 at 10:39 am

  #1758048

  How do you know it is very slow? What have you measured?

  What is the network type you are replicating over? Is it a LAN or WAN?

  I recommend you read this article, http://technet.microsoft.com/en-us/library/ms152522(v=sql.105).aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question