SQL Server Performance

Table performance, while replicating

Discussion in 'Performance Tuning for SQL Server Replication' started by sxusai, Sep 14, 2005.

  1. sxusai New Member

    Hello,

    I have setup Snapshot replication from server-1 to server-2.

    The replication is scheduled to run every 2 hours.

    When the replication runs, the access to the tables being published, slows dramatically.
    I tried breaking down the publications into 5 seperate groups..This seem to have resolved the issue to some extent, however with increase in data volume, the individual publications are also slowing the table access.

    What may be the cause and resolution ?

    Thanks
  2. dineshasanka Moderator

  3. satya Moderator

Share This Page