SQL Server Performance

Replication alert

Discussion in 'Performance Tuning for SQL Server Replication' started by sureshtp2sureshtp2, Jul 23, 2005.

  1. sureshtp2sureshtp2 New Member

    Hi,

    I am performing a replication of pull subscription from X(publisher) to Y server(subscriber) via Z(distributor). Y server is very slow in accessing Z server. So i have copied the snap shot from Z to Y maually and started the distribution agent by updating the sanp shot loc. but it is running for 3 hrs showing the status as "Delivering replication transactions" on distribtion agent and it is not at all showing "snap shot or bulk copyinmg status".It is taking time but fetching the snap shot folder from local system..amazing..

    I tried with the same database with different server but it completes the applying sanp shot in 30 mins.

    Could you please help inb this situation


    Thanks,
    Suresh.
  2. satya Moderator

    Any difference in the edition, mdac version and service packs between the servers?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page