SQL Server Performance

Network latency and retry attempts

Discussion in 'Performance Tuning for SQL Server Replication' started by hooperdba, Mar 8, 2007.

  1. hooperdba New Member

    I'm experiencing some network latency which sometimes causes my replication to fail. (timeout - was retried 10 times)

    I would like to increase the number of retries to maybe buy me some more time.

    Is this the right way?

    Goto publisher/agent properties/adavanced
    then change retry attempts


    Do I have to stop syncrosizing and then restart to pick up change??

    Thanks
  2. Jon M Member

    I have a Pull Subscription from a Transactional Replication. Normally, I would go to the Pull Subscription properties and from the Synchronization tab I will click on the Distribution Agent Properties button.

    Try increasing the QueryTimeout value in the Distribution Agent properties by adding
    "-QueryTimeout {no. of seconds}".

    Jon M

  3. MohammedU New Member

    Yes, you need to restart the agent to take effect ....
    You can add another schedule to the underlying distribution agent to job to run every 10 minutes so that you don't need to start manually every time when it fails..


    Read the following article...
    Transactional Replication Performance Tuning and Optimization
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page