When using Transaction Replication, are there any restrictions around selecting data from the subscriber whilst transactions are being applied to it?
i.e. can selects be made against tables to which updates are being applied?
Will performance of these selects suffer whilst transactions are being applied?
Best Answer
There are no restrictions for selecting data on subscriber side.
Yes, depending on the frequency of the log-reader agent there might be blocking when the replicated transactions are being applied to subscriber.
If your publication database is very active - generating lots of changes that needs to be applied to subscriber, I would suggest to change the database option to
SET READ_COMMITTED_SNAPSHOT ON
for publication and subscription databases. TEST IT before implementing in PROD !!As a side note:
Refer to : Enhance General Replication Performance