Unanswered: DB Freezes When Replication Agent Cant Deliver
We are repeatedly having the trouble of our publisher database becoming unresponsive during network problems.
We have publisher in carribean, distribution agent in canada and subscribers all over. The problem comes when publisher cant deliver to distributor due to network outages.
We are planning on moving the distributor to the carribean ultimately but that will take a while, and our application repeatedly needs to be restarted due to these freezes.
Does anyone know of this problem & possible ways to fix it in the short term (short of changing our replication topology).
is this a bug in replication?
ps.database is merge & transactional pubs. (some tables merge/some trans)
Yes, replication is over the internet, so cant really troubleshoot the outages - have been various ddos attacks affecting us.
have found no signs of trouble in error logs/eventvwr - only support saying apps are freezing & claiming is db...guess ill have to take a look at processes for deadlocks while frozen (unfortunately thats usually around 4am! :-(