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

SELECT in subscriber table slow down the transactional replication sync with subscriber Expand / Collapse
Posted Wednesday, November 14, 2012 5:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 12, 2015 5:27 AM
Points: 33, Visits: 478
I have setup a transactional replication publisher with local distributor and subscriber using pull subscription.

During the day, it is running fine about 5000 command .

At night , there are a sql agent schedule job at subscriber server which will select from the replicated table with some condition and perform insert to other table .

The subscriber is running the pull subscription in every 1 hours and the sql agent job is running the "select from into " at every 1 hours also .
All tables use in the select statement is also a replicated-table .

Question :

1. When the select job is select the same table with same column , does it block the insert or update of the replication ?
2. Will it slow down the replication update to the subscriber table when the select job is selecting the same table and data ?
3. Any solution to prevent the select to blocking the insert and update in the transactional replication ?

Post #1384557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse