Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Load on publisher in case of PUSH replication Expand / Collapse
Posted Tuesday, June 4, 2013 2:46 AM



Group: General Forum Members
Last Login: Monday, April 4, 2016 1:44 AM
Points: 434, Visits: 1,138
Suppose we have distributor configured separate than publisher. And we are using PUSH method for transactional replication. Then what will be load effect on Publisher, either distributor will take the whole load of PUSH or there will be some load on publisher also?

Atif Shehzad
Zin Technologies
Post #1459605
Posted Friday, June 7, 2013 8:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 21, 2016 5:59 AM
Points: 202, Visits: 776
When creating the snapshot the publisher places some locks to know where to start transferring transactions to the distribution database. Then the data for the snapthot has to be read.

When replication is running the load is that the Log Reader Agent has to read the transaction log to trace changes on the published tables.

I think that's it.
Post #1461123
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse