deadlocked Merge agents

I have a deadlock problems with my merge agents.
Situation:
- 1 Publisher, 3 Subscribers
- All three merge agents are stopped (to simulate a network connection
failure, so temporary no replication)
- On each database a lot of items (for example 1200) are inserted in table X
- Then all three merge agents are started at the same time (to simulate
network connection is ok again)
Result is:
All merge agents seems to be uploading changes from the subsriber to
publisher. After a while, Enterprise Manager shows for each merge agent the
message 'The agent is suspect. No response within last 10 minutes'. And it
looks like that each merge agent is hanging and doesn't do anything anymore.
When I stop two merge agents, the third is doing its job again.
Is it possible that multiple merge agents running at the same time result in
a deadlock situation? How can I solve/prevent this?
Thanks in advance,
Marco Broenink
It doesn't mean you are getting deadlocks, what it means is that procs were
fired and they haven't returned any info back to the merge agent yet.
if you get deadlocks you will get a deadlock message. This is quite normal.
If the agent fails, restart it, chances are very good it will clear this the
second time.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Broenink" <MarcoBroenink@.discussions.microsoft.com> wrote in message
news:53566E14-0AD1-4336-B271-00462325E166@.microsoft.com...
> I have a deadlock problems with my merge agents.
> Situation:
> - 1 Publisher, 3 Subscribers
> - All three merge agents are stopped (to simulate a network connection
> failure, so temporary no replication)
> - On each database a lot of items (for example 1200) are inserted in table
X
> - Then all three merge agents are started at the same time (to simulate
> network connection is ok again)
> Result is:
> All merge agents seems to be uploading changes from the subsriber to
> publisher. After a while, Enterprise Manager shows for each merge agent
the
> message 'The agent is suspect. No response within last 10 minutes'. And it
> looks like that each merge agent is hanging and doesn't do anything
anymore.
> When I stop two merge agents, the third is doing its job again.
> Is it possible that multiple merge agents running at the same time result
in
> a deadlock situation? How can I solve/prevent this?
> Thanks in advance,
> Marco Broenink
|||thanks for the reply.
My problem is that the performance of the merge agents has become very very
bad in this situation. As soon as two merge agents have been stopped, the
third is replicating normally again.
When three merge agents are trying to replicate changes of the same table, I
guess there should be two agents being blocked and waiting for the third
doing its job. In this situation ALL three merge agents are being blocked (or
seemed to block!). This block-situation can take more then 60 minutes! So the
merge agents are not really blocking eachother, but decreasing the
performance to very bad.
thanks,
Marco
"Hilary Cotter" wrote:

> It doesn't mean you are getting deadlocks, what it means is that procs were
> fired and they haven't returned any info back to the merge agent yet.
> if you get deadlocks you will get a deadlock message. This is quite normal.
> If the agent fails, restart it, chances are very good it will clear this the
> second time.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Marco Broenink" <MarcoBroenink@.discussions.microsoft.com> wrote in message
> news:53566E14-0AD1-4336-B271-00462325E166@.microsoft.com...
> X
> the
> anymore.
> in
>
>