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 ?