SQL Server Performance

effect of changing "Max Text Repl Size"

Discussion in 'Performance Tuning for SQL Server Replication' started by aaronh, Jun 24, 2004.

  1. aaronh New Member

    Hey Everyone,
    I have come across an issue here which I was curious if anyone else would know. We have an issue right now with replication where one of our large html files is being replicated and we're actually not able to replicate it because it is larger then the default max text repl size of 65536. I know it has a maximum value 2147483647 bytes, but I'm hesitant to change this setting before I know what effects it will have on the following:


    • what effect will it have on current replication jobs
    • what effect (if any) will it have on the data currently being touched by that job
    • Will changing this need to be done when all replication is stopped or will it even effect a replication job if it is currently runing


    If anybody has ever changed this value before after a SQL server is up and running in a production environment, please let me know how you approached it.

    Thanks,

    Aaron
  2. vbkenya New Member

    never had to change it but the documentaion claims that The setting takes effect immediately (without a server stop and restart).

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
  3. satya Moderator

    I never had changing this on fly and you must test the setting before deploying on production, every setup is a different case.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page