By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,826 Members | 815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,826 IT Pros & Developers. It's quick & easy.

Setting maximum number of merge agents

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a

"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

P: n/a
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.