Sql-server – the impact of setting “max text repl size (B)” to -1

sql serversql-server-2012

I have a table replicated via transactional replication that is throwing this error message:

Length of LOB data (68983) to be replicated exceeds configured
maximum 65536.

This can be resolved by adjusting the "max text repl size (B)" SQL Configuration value from the default of 65536.

I see two options:

  1. Adjust the value higher than required for this situation
  2. Set the value to "-1" which indicates no limit

My question is: What is the downside of setting "max text repl size (B)" to -1?

I appreciate any feedback!

Best Answer

What is the downside of setting "max text repl size (B)" to -1?

I would not set the value to -1 (limitless). I would instead find out the max datalength of your lob data and set it accordingly with a 10% buffer. This way you have more control of what and how much gets into distribution.

I can see that in an unlikely situation, setting of -1 can cause high network latency if the blob data to be replicated is of a much larger size.

Related Question