Prev: SQL2008 Replication / synchronization with SQL Express Editon
Next: database as well as information
From: Steven on 20 Oct 2009 15:23
Using MSSQL 2005 x64 enterprise. I understand that increasing the Max Text
Repl Size will increase latency in replication, but is it the setting that
causes increased latency, or is it the LOB data being replicated that causes
the latency? In other words, if I increase the size to 2147483647, even
though no LOB data exceeds the 65536 default setting, will that increase
latency as opposed to keeping the default 65536 setting?

Thanks


From: Hilary Cotter on 20 Oct 2009 19:39
Max text repl size merely limits the amount of text you can insert in a
column on a replicated table.
Replicating text does increase latency. Changing this value can limit the
amount of which is replicated and therefore can affect latency.

"Steven" <Sykong(a)hotmail.com> wrote in message
news:egZ$brbUKHA.4004(a)TK2MSFTNGP05.phx.gbl...
> Using MSSQL 2005 x64 enterprise. I understand that increasing the Max
> Text Repl Size will increase latency in replication, but is it the setting
> that causes increased latency, or is it the LOB data being replicated that
> causes the latency? In other words, if I increase the size to 2147483647,
> even though no LOB data exceeds the 65536 default setting, will that
> increase latency as opposed to keeping the default 65536 setting?
>
> Thanks
>
 | 
Pages: 1
Prev: SQL2008 Replication / synchronization with SQL Express Editon
Next: database as well as information