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

  • chris.roddis-ferrari (11/15/2013)


    Stats were updated for the MSreplication_subscriptions table.

    I was wondering if you'd updated all the stats on the 2008 subscriber since upgrading the server?

    I would consider running sp_updatestats on the db then look considering updating the stats with fullscan on the biggest tables at the subscriber.

    Its possible that the different agent versions are using different execution plans for the replication stored procedures. Since the latency appears to be at the running of commands at the subscriber, this is where I would be looking.