SQL Server 2005 SP2. Push Replication. One publication. One subscription. Distribution on publisher.
The Replication Monitor shows 800k commands waiting to be delivered in the distribution database. The subscriber database is up to date. This has been ticking up since I reinitialized the subscription two days ago.
The following query:
undelivered = sum(UndelivCmdsInDistDB)
MSDistribution_status s with (nolock)
join [db].dbo.sysarticles a
on s.article_id = a.artid
group by s.agent_id
Agent_id 1 and 2 are virtual.
Are these two pieces of info related? I am concerned that the distribution database will grow. I am trying to figure out replication, but it has been tough. Any help is appreciated.
View Complete Post