Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Thursday, March 19, 2015 5:54 AM
Points: 431, Visits: 1,055
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: Friday, March 27, 2015 11:20 AM
Points: 202, Visits: 755
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