dbTalk Databases Forums  

Merget Replication Takes time.

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clients Merget Replication Takes time.

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Merget Replication Takes time. in the microsoft.public.sqlserver.clients forum.



Reply
Page 4 of 4 < 1 2 3 4
 
Thread Tools Display Modes
  #31  
Old   
Rick Byham, \(MSFT\)
 
Posts: n/a

Default Re: Merget Replication Takes time. - 09-11-2008 , 11:59 AM





Keep in mind that merge replication is expected to have some latency. If you
need concurrent data, and 1 second sounds like you do, consider using
distributed transactions.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote

Quote:

"Pascal Deliot" wrote:

As far as remember, continuous mode means "run the merge each 5 seconds".
After that, you must add the time taken by each merge process that can be
long depending on the load, the retention period, the use of filters...

Then no, 1 seconds can't be a reasonable target.

Pascal

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news:8C660BB3-E7DF-40A6-8D3F-5ED1CB9B2B96 (AT) microsoft (DOT) com...
I created Merge Replication (Push Data: Run Continuesly) into two
production
boxes and it takes around 15-20 seconds to merge into Subscriber.

Is it normal? or we can do configuration to replicate if 1 second?

Thanks


Reply With Quote
Reply
Page 4 of 4 < 1 2 3 4

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top