all groups > sql server replication > december 2005 >
You're in the

sql server replication

group:

Merge Agents Don't "Retry" After SQL Server Error 8645?


Merge Agents Don't "Retry" After SQL Server Error 8645? Justin H.
12/14/2005 10:43:21 AM
sql server replication:
During a memory- and CPU-intensive nightly database update process, the
merge agents (running on the server) for two subscribers failed with
SQL Server Error 8645 (A time out occurred while waiting for memory
resources to execute the query). It's not surprising to see this error,
but the fact that the agents did not retry as configured is surprising.


I discovered that this message is listed as a "severity" of 17 - is
there some threshold that prevents a retry by the agent? A restart of
the agent was successful.

Justin H.
Re: Merge Agents Don't "Retry" After SQL Server Error 8645? Hilary Cotter
12/14/2005 11:13:24 PM
How many merge agents do you have? Are you limiting the number of concurrent
merge agents?

--
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

[quoted text, click to view]

Re: Merge Agents Don't "Retry" After SQL Server Error 8645? Justin H.
12/15/2005 1:06:26 PM
There are only two subscribers, so two merge agents with no concurrency
limit configured. I'm not so concerned about the error as long as a
retry happens as configured.
AddThis Social Bookmark Button