Post reply

Replication Issue

  • April 24, 2006 at 7:20 am

    #113957

    We have a transactional replication set up on our production env where replication goes to 2 subscribers from the publisher. Thisngs have been going pretty smooth for past couple of years until lately replication has become very slow. Is there anything under publishers or subscriber end that might deteriorate over time so see such a change. liek for instance when a table scan slows down if we do update statistics and that does show perf change something similar to that which could speed up the replication. Volume of data going from publisher to distribution is teh same and no configuration has been changed on dist/publisher/subscriber side.

    Any thoughts or ideas on this.

    TIA

     

  • April 24, 2006 at 10:21 am

    #633849

    tricky to be sure - you might want to make sure you're not short of disk space or suffering from ntfs fragmentation in the snapshot/transaction folder. You might want to check the tran logs on the database are not clogged up.

    the obvious first check is that you're not suffering network problems - bandwidth / contention

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • April 26, 2006 at 3:55 am

    #634236

    You can use performance monitor counters to get a feel for the latency between the publisher and the distribution database, and between the distribution database and the subscribers.  Then you should have an idea of where the problem is and you can start looking at network connections, parameters on the replication agents, and so on.

    John

  • April 26, 2006 at 1:30 pm

    #634424

    It's also possible that the publisher has a lot more articles than before. If this is the case and the distributor is on the same server as the publisher, then you should consider to add a new server for the distributor.

  • April 28, 2006 at 7:52 am

    #634839

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql2k_replperf_tran4.asp

     

    This should help. I found it very useful. There are a number of configs you can analyse and change depending upon the setup of your system.

    I tweaked it with a few of the changes described in the article but also split the distributor from the publisher which was a major task but has proved extremely worthwhile.

    Paul R Williams.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply