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 http://www.sql-server-performance.com/replication_tuning.asp —————————————-
http://spaces.msn.com/members/dineshasanka

As you are in snapshot replication, referhttp://www.sql-server-performance.com/snapshot_replication_tuning.asp and BTW how often the Snapshot Agent is running. 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.
]]>