SQL Server Performance

Merge replication question

Discussion in 'Performance Tuning for SQL Server Replication' started by fredo3000, Feb 5, 2004.

  1. fredo3000 New Member

    a 4 server merge replication over a T1 connection about 100 users connecting each server ,... effective or poor desicion?
  2. Twan New Member

    <br />that's really a question like how long is a piece of string... <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br /><br />depends on:<br />- what else is done over the T1<br />- how often is data changed in each area<br />- how often is it replicated to the other areas<br />- what is the likelyhood of conflicts<br />- when you say 100 users connecting, is that via a web app?<br />- what security is there on the web app (Windows Integrated, anonymous, etc.)<br />- are all four areas in the same NT domain/2k domain<br />etc.<br /><br />If the databases are fairly static and the likelyhood of conflicts is low and accessed via fat applications in separate domains, then yes it could be a good decision...<br /><br />If the application is actually a web application with anonymous access, then it might be better to host the application/database in one location, since the site over t1 should give good performance anyway<br /><br />Cheers<br />Twan
  3. fredo3000 New Member

  4. fredo3000 New Member

    BTW
    we do only have 1 domain on all 4 sites
    and the only data passing through the T1 is the merge data!
  5. Twan New Member


    Is it a web enabled application used on all four sites? Is the link reliable or does it come down from time to time? What are your uptime requirements in the four sites?

    So you have another connection between the sites for domain replication, and the domain is split into multiple NT sites to control replication?

    loads of ifs and buts sorry...

    Cheers
    Twan

Share This Page