473,381 Members | 1,428 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,381 software developers and data experts.

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 1591
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Frank Esser | last post by:
I am using SQL 8 Personal edition with sp2 applied. I set the max server memory to 32MB and leave the min server memory at 0. When my application starts hitting the database hard the memory usage...
1
by: Abdullah Kauchali | last post by:
Hi folks, I am currently getting/setting values in an HTML table with: document.getElementById(id).childNodes.nodeValue where "id" is the id of the <td> tag of the cell. This works,...
7
by: Joey C. | last post by:
Hello, I'm designing a small "briefcase" program that will allow me to quickly upload, download, and delete files in a briefcase. The only real things that I have left to do are to design a...
7
by: Egor Shipovalov | last post by:
I'm implementing paging through search results using cursors. Is there a better way to know total number of rows under a cursor than running a separate COUNT(*) query? I think PostgreSQL is bound...
2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
2
by: David Mathog | last post by:
Is there some method for restricting the maximum number of characters that will be emitted by a printf() function? Where printf() here is generic and refers to sprintf, fprintf, etc. Here's an...
4
by: Joseph | last post by:
I have an intranet application that I setup using windows authentication through IIS basic authentication. Is there a way to set a timeout, so that after ten minutes the user will be prompted...
1
by: laredotornado | last post by:
Hi, I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed using Apache's apxs and the php library was installed to /usr/local/php. However, when I set my "error_reporting"...
29
by: garyusenet | last post by:
I'm trying to investigate the maximum size of different variable types. I'm using INT as my starting variable for exploration. I know that the maximum number that the int variable can take is:...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.