Table performance, while replicating | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Table performance, while replicating

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
There are several measures you can take to improve the performances when replication
consider following tips —————————————-

As you are in snapshot replication, refer and BTW how often the Snapshot Agent is running. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.