January 25, 2010 at 1:43 pm
Lately I am having problem with our Transactional replication. The distributiopn agents get hung even though they are set to run every 5 min. .The no. of undistributed commands rise and I have to manually stop/start synchronization for each distribution agent and it works. How can I prevent this from happening?
Any help is appreciated.
January 26, 2010 at 6:53 am
How come you set it up as once every 5 min? That makes the distribution commands grow and thus causing the problem. You could set the distribution as immediate.
Also are you by any chance sharing the distribution database with the subscriber or publisher?
-Roy
January 26, 2010 at 3:42 pm
Agents set to run every five min. has been working fine from a long time as we don't have that many transactions. Distributor and publisher are the same server.
January 27, 2010 at 8:02 am
Have you checked for blocking processes? Also, are you using any triggers on the affected tables?
January 27, 2010 at 8:56 am
There is no blocking and no triggers.
January 27, 2010 at 4:57 pm
How many distibution agents do you have running? I have seen this problem before where a large number of concurrent distribution agents can cause the desktop heap to run out of memory and the agent hangs. Have a look in the event log for OS errors.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply