SQL Server Performance Forum – Threads Archive
SQL server replication performanceI 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.
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
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