SELECT in subscriber table slow down the transactional replication sync with subscriber

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » SELECT in subscriber table slow down the...

SELECT in subscriber table slow down the transactional replication sync with subscriber

Rate Topic

Display Mode

Topic Options

Author

Message

stanley_1982

Posted Wednesday, November 14, 2012 5:27 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 06, 2013 10:27 PM
Points: 29, Visits: 422

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 »

Permissions