Post reply

Increase Performance

  • April 18, 2008 at 10:57 pm

    #186810

    I have a db structure as follows for replication

    DB1----transactional replication------->DB2------merge replication---->DB3

    |

    |--------merge replication---->DB4

    |

    |--------merge replication---->DB5

    and so on

    Can someone please tell me how to increase the performance as performance from db1 to db2 is critical.

    Also, what is the maximum number of publications i can make on DB2?

    Is there any other appropriate way to do such kind of set up?

  • April 19, 2008 at 11:34 am

    #804666

    the critical indicator in relication monitor is ultra sensative, you can change it to be less. I never care for those indicators as long as i'm pumping 100+ commands per ms ( u can see this via the perfmon ).

    -----------------------------
    www.cbtr.net
    .: SQL Backup Admin Tool[/url] :.

Viewing 2 posts - 1 through 2 (of 2 total)

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