SQL Server Performance

Merge Replication error

Discussion in 'Performance Tuning for SQL Server Replication' started by crfilho, Jun 21, 2005.

  1. crfilho New Member

    Hi,

    I am getting error from a Merge replication:

    "The process could not deliver insert(s) at the 'Subscriber'."

    I have another 3 transactional replications involving same servers and they're working properly.

    Thanks,


    Claudionor C. Rocha Filho
  2. satya Moderator

    What is load (no.of rows) of this snapshot?
    Do you have any other application like virus scanner on SQL Server>?

    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.
  3. crfilho New Member

    Hi,

    Thanks for your reply,

    In then initial snapshot there are about 100,000 rows. But the initial snapshot was aplied properly. After that, sometimes the error occurs.

    There is a Norton Enterprise Antivirus installed on the both servers (Publisher and Subscriber)

    How can i see the no of rows there will be transfered in the merge replication after the initial snapshot was aplied?

    Thanks again



    Claudionor C. Rocha Filho
  4. satya Moderator

    I suggest to stop the AV scanner during the snapshot process in order to continue the merge replicaiton.

    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.
  5. Ray D New Member

    Can you show full error message? (add parameter -OutputVerboseLevel 3 to the agent's command line)

    WBR, Vlad A. Scherbinin

Share This Page