468,104 Members | 1,293 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,104 developers. It's quick & easy.

Setting maximum number of merge agents

Jim
I have a situation with a 6 server setup whereby merge agents
will not run if other merge agents are alreay running. Basically
we have a 5 laptop, one tower config with the tower being the
publisher. In theory we want to be able to hook a laptop up
and have it sync within, say, 5 mins. Trouble is, if agents for
the other laptops are running (trying and failing to connect because
those laptops aren't connected) then the agents for the laptop that
*is* connected won't run. It seems to be a 'maximum number of running
agents' issue. Is this is user defined setting, and if so where can I set it?

Many thanks, sorry if this has been answered many many times before.

Jim
--
Find me at http://www.ursaMinorBeta.co.uk
"Brace yourself, this might make your eyes water."
Jul 20 '05 #1
3 1400
Jim
In article <sl*****************@odin.magrathea.local>, Jim wrote:
I have a situation with a 6 server setup whereby merge agents
will not run if other merge agents are alreay running. Basically
we have a 5 laptop, one tower config with the tower being the
publisher. In theory we want to be able to hook a laptop up
and have it sync within, say, 5 mins. Trouble is, if agents for
the other laptops are running (trying and failing to connect because
those laptops aren't connected) then the agents for the laptop that
*is* connected won't run. It seems to be a 'maximum number of running
agents' issue. Is this is user defined setting, and if so where can I set it?

Many thanks, sorry if this has been answered many many times before.

Forgot to add - this is MSSQL2000 running under Small Business Server
W2K.

Jim
--
Find me at http://www.ursaMinorBeta.co.uk
"Brace yourself, this might make your eyes water."
Jul 20 '05 #2

"Jim" <ji*@odin.magrathea.local> wrote in message
news:slrncbtvep.2ef8.ji*@odin.magrathea.local...
In article <slrncbtv0e.2dt1.ji*@odin.magrathea.local>, Jim wrote:
I have a situation with a 6 server setup whereby merge agents
will not run if other merge agents are alreay running. Basically
we have a 5 laptop, one tower config with the tower being the
publisher. In theory we want to be able to hook a laptop up
and have it sync within, say, 5 mins. Trouble is, if agents for
the other laptops are running (trying and failing to connect because
those laptops aren't connected) then the agents for the laptop that
*is* connected won't run. It seems to be a 'maximum number of running
agents' issue. Is this is user defined setting, and if so where can I set it?
Many thanks, sorry if this has been answered many many times before.

Forgot to add - this is MSSQL2000 running under Small Business Server
W2K.

Jim
--
Find me at http://www.ursaMinorBeta.co.uk
"Brace yourself, this might make your eyes water."


See sp_changemergepublication in Books Online - there is a
max_concurrent_merge parameter. But I have to say that I've never used merge
replication myself, so you might want to post on
microsoft.public.sqlserver.replication to see if there are any problems
associated with changing this value, or if there's a completely different
way to handle the issue.

Simon
Jul 20 '05 #3
Jim
Simon Hayes <sq*@hayes.ch> wrote:
See sp_changemergepublication in Books Online - there is a
max_concurrent_merge parameter. But I have to say that I've never used merge
replication myself, so you might want to post on
microsoft.public.sqlserver.replication to see if there are any problems
associated with changing this value, or if there's a completely different
way to handle the issue.


Many thanks for the info. I actually got around it by changing the
number of retries to zero and making each laptop's start time offset by
one minute. This way there's never more than one set of agents running
at one time (unless there's a huge amount of data to merge). Seems to
work a treat :-)

Jim
--
Find me at http://www.ursaminorbeta.co.uk AIM/iChatAV: JCAndrew2
"We deal in the moral equivalent of black holes, where the normal
laws of right and wrong break down; beyond those metaphysical
event horizons there exist ... special circumstances" - Use Of Weapons
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Frank Esser | last post: by
1 post views Thread by Abdullah Kauchali | last post: by
7 posts views Thread by Joey C. | last post: by
2 posts views Thread by Kums | last post: by
2 posts views Thread by David Mathog | last post: by
4 posts views Thread by Joseph | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.