Home Forums SQL Server 2008 SQL Server 2008 - General Transactional Replication Performance Issues After Migration From 2000 to 2008 RE: Transactional Replication Performance Issues After Migration From 2000 to 2008

  • Tracer Token show Publisher to Distributor (same box) as a couple of secs and all the latency is Distributor to Subscriber - 12 minutes in the one I just did. There is no blocking on the distribution db, just a ASYNC_NETWORK_IO wait of about 2 secs on the distribution process. There has always been a level of blocking on the subscriber even before the upgrades started, but this has never caused performance issues. I am not able/don't know how to tell if this has increased