2

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!

1

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.

  • Actually, setting to -1 is not bad when you are not sure of your largest lob datalength. Whether replication latency is impacted is by the real blob data volume and size. Just like whether you set a column to varchar(max) depends on your business requirement. I remember in one replication environment, I set this to -1 because from time to time (like once in a week), I will have a few records whose datalength is beyond 64K, and I do not see any issue at all. – jyao Mar 27 '18 at 4:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.