Hi All, On Friday we configured Transactional Replication for one Publisher/Distributor and 2 Subscribers in production. We configured Replication for 3 Databases DB1 (70 GB), DB2 (1 GB) and DB3 (27 MB) The initial Snapshot was sync without any problems. But, there is latency (14 hrs) in Replication today that is setup for DB1 (70 GB). totally 10 tables were set up for replication from this database and one table is around 30 GB. This table is indexed heavily (9 NC indexes with no Clust Index) Last week, we tested the same replication in development environment and it was running fine without latency. Not sure where to investigate since i am new to replication. Please guide me. Let me know if you need any more details
For the production servers, do you implement replication within LAN or WAN? if WAN what technology and speed ? It is prefered (not for replication only) to use clustered index for PK indexes for performance, but index is not replicated. It should be maintained for every publisher/subscriber. investigate in the replication monitor , the history of agent, may you find network problems.
