I have a database that has about 200 filtered publications. When we run snapshots it drags down the merge processes and it takes a long time to recover because of the locks.
Is there a way to create a snapshot on a busy database without slowing down the running subscriptions.
what would be the impact of snapshot isolation. ( I realize its not talking about the actual snapshot)