we have transactional replication set up with all the agents running at source database. The synchronization status is stuck at "delivering replication transactions". The replication latency in replication monitor says excellent.
when I check sp_browsereplcmds. it ever ends. It has over more than millions of rows of output.
We were having trouble with this replciation recently because at the source db. they run a large batch. So we decided to schedule snapshot agent to run exactly after that batch but the snapshot doesn't seem to helping out with the latency.
what should be done to resolve the issue. Please help. thanks.
View Complete Post