SQL Server Performance

SQL server replication performance

Discussion in 'Performance Tuning for SQL Server Replication' started by registeraccount2007, Jan 3, 2007.

  1. registeraccount2007 New Member

    I am newbie to SQL server. Supposing two SQL servers are in the same network with continuous replication running, how is the performance of replication provided data is keep increasing all the time? If data of server A is replicated to B, can I see the same data at B within 1 min? Thank you.
  2. madhuottapalam New Member

    What u are mentioning is Transactional Replication. In this type of replication your subscriber will have near-Real time data. 'Near Real-Time' because it again depends on many factors. Anyhow, in BOL (Books Online for SQL 2000) goto Contents Tab and select Replication. u have very detailed description about Replication there.

    Madhu
  3. dineshasanka Moderator

    what is your replication type. I think it is trnasactional

    there are few tips for you


    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page