January 24, 2002 at 11:04 am
We have set up merge replication between two clustered SQL Server 7.0 servers on the same domain. We set it up to run continously. However, we find that it takes between 5 to 30 minutes to send the updates from one server to the other.
Has anyone seen this before? Does anyone have an idea what could cause this slowness.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
January 24, 2002 at 5:54 pm
Hi Robert,
There is one Knowledge Base article which talks about SQL 7 and slow merge replication. I don't know if the conditions match yours, but here's a look:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281295
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 25, 2002 at 8:28 am
Brian:
Thanks for the reference. I read the article and according to Microsoft the problem with slowness was fixed with SP3 which we are currently using (sorry for not mentioning this in my first post). Maybe it really isn't fixed as I know our merge replication could be sending large volumes of data, however in some cases I think its only replicating one or two rows and still takes 5 minutes or more.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply