Multiple distribution agent sessions for one subscriber ?

I'm running SQL 2000 service pack 4 - on my publisher, my distribution and
subscriptions servers are SQL 2005 service pack 1...
Using replication monitor - I look at 'distributor to subscriber' history
and I see 3 distribution agent sessions running on one subscription...
select * from distribution..msdistribution_status gives :-
article_id agent_id UndelivCmdsInDistDB DelivCmdsInDistDB
-- -- -- --
31 300 199509 0
31 301 199574 0
31 302 65 199509
When I do a select count(*) from msrepl_commands I only see
199,000+ rows .
My question is this - is it a problem that I have multiple agents running ?
Have I done something wrong when setting up my replication
publication/subscription ?
Any advice appreciated.
Thanks in advance,
Have a look at MSsubscriptions - I would guess that you have 3 subscriptions
which accounts for the 3 rows returned. The fact that you get fewer rows
returned from a straight count of msrepl_commands is very odd. Is this
reproducible? Perhaps rows were added between the 2 commands? If it is
reproducible then I wonder if there are 2 agents for the same subscriber
which shouldn't be possible. The MSsubscriptions table will give more info.
HTH,
Paul Ibison
|||Paul,
yes - I have 3 rows in MSSubscriptions. Interestingly, for two of the rows I
have a subscriber_db of 'virtual'.... the db is only correct in one row.
Is there anything else I can check ?
"SteveH" wrote:

> I'm running SQL 2000 service pack 4 - on my publisher, my distribution and
> subscriptions servers are SQL 2005 service pack 1...
> Using replication monitor - I look at 'distributor to subscriber' history
> and I see 3 distribution agent sessions running on one subscription...
> select * from distribution..msdistribution_status gives :-
> article_id agent_id UndelivCmdsInDistDB DelivCmdsInDistDB
> -- -- -- --
> 31 300 199509 0
> 31 301 199574 0
> 31 302 65 199509
> When I do a select count(*) from msrepl_commands I only see
> 199,000+ rows .
> My question is this - is it a problem that I have multiple agents running ?
> Have I done something wrong when setting up my replication
> publication/subscription ?
> Any advice appreciated.
> Thanks in advance,
|||The only thing I could find was this:
http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.replication/2007-03/msg00049.html
In your case I'd open a PSS case and see if this is listed in their database
- it might be that you can get some inside info and / or a hotfix. Meanwhile
I'll see if I can get some more info...
Paul Ibison