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
Author
Message
Posted Tuesday, June 4, 2013 2:46 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:27 AM
Points: 431, Visits: 972
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?
Thanks


=============================================================
Atif Shehzad
DBA
Zin Technologies
Post #1459605
Posted Friday, June 7, 2013 8:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:31 AM
Points: 194, Visits: 717
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