June 5, 2008 at 12:55 pm
The Number of Commands in the Distribution DB waiting to be Applied to the Subscriber is NOT going down and the and the Estimated Time to Apply These Commands hasn't changed from 00:15:08 in the past hour. And yes, I've Refreshed numerous times.
What's up?
June 6, 2008 at 9:02 am
wjones21 (6/5/2008)
The Number of Commands in the Distribution DB waiting to be Applied to the Subscriber is NOT going down and the and the Estimated Time to Apply These Commands hasn't changed from 00:15:08 in the past hour. And yes, I've Refreshed numerous times.What's up?
If you are using transactional replication this means that your distribution agent is not delivering the transactions for some reason. It could be many things, for example:
-Agent is not running or disabled
-All transactions were performed in one single large modification and therefore is taking a long time to commit on the replica.
-There is contention on the Distribution database due to other agents activity and your agent is timing out.
... and I could go on and on ...
So at least you should start with the above to verify such thing.
* Noel
June 6, 2008 at 9:07 am
Thank you! I will start there.
June 6, 2008 at 9:12 am
Also, if you have more than one subscriber, the commands don't go down until ALL subscribers have gotten them.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 6, 2008 at 9:14 am
Nope, just one subscriber.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply