SQL Server Performance Forum – Threads Archive
Table performance, while replicatingHello, 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 —————————————-
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.