all groups > sql server replication > february 2004 >
You're in the

sql server replication

group:

Merge Agents will not restart


Merge Agents will not restart Steve
2/6/2004 1:23:54 AM
sql server replication:
I have 14 merge agent jobs that are replicating to two
different SQL 2000 servers, They all run OK on their own
but when i try to run them all together it will not let me
restart more than 8 of them. They all run under the same
RE: Merge Agents will not restart chandra NO[at]SPAM online.microsoft.com
2/7/2004 12:10:34 AM
Hi -
When you tried to restart, were you getting any error message?
If so, what is the error message?
how are you running the agent? On schedule or continuous ?

Regards,
Chandra
--------------------
||Content-Class: urn:content-classes:message
||From: "Steve" <anonymous@discussions.microsoft.com>
||Sender: "Steve" <anonymous@discussions.microsoft.com>
||Subject: Merge Agents will not restart
||Date: Fri, 6 Feb 2004 01:23:54 -0800
||Lines: 5
||Message-ID: <b77901c3ec92$f0bf11e0$a001280a@phx.gbl>
||MIME-Version: 1.0
||Content-Type: text/plain;
|| charset="iso-8859-1"
||Content-Transfer-Encoding: 7bit
||X-Newsreader: Microsoft CDO for Windows 2000
||Thread-Index: AcPskvC/fcrHBWYNTYq6lciyRIZTEg==
||X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
||Newsgroups: microsoft.public.sqlserver.replication
||Path: cpmsftngxa07.phx.gbl
||Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.replication:47042
||NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
||X-Tomcat-NG: microsoft.public.sqlserver.replication
||
||I have 14 merge agent jobs that are replicating to two
||different SQL 2000 servers, They all run OK on their own
||but when i try to run them all together it will not let me
||restart more than 8 of them. They all run under the same
||user name. has anyone come across this before?
||
RE: Merge Agents will not restart anonymous NO[at]SPAM discussions.microsoft.com
2/9/2004 12:15:07 AM
Hi Chandra



[quoted text, click to view]
RE: Merge Agents will not restart anonymous NO[at]SPAM discussions.microsoft.com
2/9/2004 12:16:47 AM
Hi Chandra

I do not get any error messages at all, they just will not
restart, I am running on them on continuous

Thanks
Steve

[quoted text, click to view]
RE: Merge Agents will not restart skelly NO[at]SPAM online.microsoft.com
2/9/2004 9:20:02 AM
Hi,

By default, SQL Server is limited to 100 simultaneous merge agents running.
This is much higher than the 8 agents you can run. Please check this
registry entry and verify that the value for the merge agent is high enough.

HKLM\Software\Microsoft\MSSQLServer\SQLServerAgent\Subsystems

If the value is set to 100, there may not be enough resources on the server
to start all the merge agents at the same time. SQL Server Desktop Edition
(MSDE) is limited in the number of simultaneous connections, so you might
be hitting that limitation.


Regards,
Shirley
SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
AddThis Social Bookmark Button