We conduct backup/restore (every 24 hours) on an OLTP database for reporting and SSRS queries. This prevents contention from simultaneous writes and reads; preventing locking, blocking, writer-reader deadlocks.
Now we want to apply transactional replication (to obtain more real time data). However, would the same issue occur?
If the reporting subscription database is being written into, updated/deleted, and we have read queries, would we still get the locking, blocking issue?
Although at least it would not be on a live OLTP system.