Do long-running and locking queries on subscriber databases cause performance issues on the publisher dbs?

by cloudsafe   Last Updated August 14, 2019 10:06 AM

One of our servers has a subscriber database. I've not used replication before and cannot find information on how the mechanism works. Does the publisher have to wait on the replication completing before transactions are committed or does it make use of a queue or the transaction log before applying changes to the subscriber? The subscriber is used as the back-end for a custom report builder (amongst other uses) which cannot make good use of indexes so tables are frequently locked for several minutes. I am concerned for any effects this might have on our publisher, which is on our live production server. Both publisher and subscriber are in Full Recovery.



Related Questions




From 2008R2 to 2016 - Replication

Updated June 19, 2017 15:06 PM

how to replicate articles from different schemas?

Updated December 12, 2017 16:06 PM