NEED HELP!! SQL Merge Replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tony.digiorgio@immedient.com - 19 Jan 2005 21:02 GMT

I have a merge replication process that is having some major performance issues. The replication process seems to run just fine for about a half hour (200k records), and then it hits a brick wall. I continually get the message:

"The process is running and is waiting for a response from one of the backend connections"

Once I get this message, the process will then go through 4 more batch downloads (2000 records per batch), and then give me that message 2 or 3 more times and then continue to download. This appears to only happen on a specific table. I have exhausted my thoughts on this and would really appreciate ANY help.

The subscriber is running MSDE 2000 on a pentium 3 1.7GHtz machine with 1GB of RAM.

Thank you,

Thanks!

Tony D

Reply to this Message

Hilary Cotter - 19 Jan 2005 23:00 GMT

Set QueryTimeout to a larger value. You might want to post replication
related questions to microsoft.public.sqlserver.replication

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

>I have a merge replication process that is having some major performance
>issues. The replication process seems to run just fine for about a half
[quoted text clipped - 23 lines]
> Comprehensive, categorised, searchable collection of links to ASP &
> ASP.NET resources...

Reply to this Message

lltroyj - 20 May 2005 06:59 GMT

I have the same problem. Have you found a resolution? Thank Yo

Reply to this Message

Hilary Cotter - 20 May 2005 15:56 GMT

what problem?

Signature

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

> I have the same problem. Have you found a resolution? Thank You

Reply to this Message