SQL Server Performance Forum – Threads Archive
Replication performance with 300 users
We are designing a new system that requires off-line access to data. We are planning to use Merge replication to keep the remote users databases (MSDE or Personal Edition) current with the central server. The system we are replacing uses Lotus Notes and typically, 30-90 people are replicating information concurrently. We expect that would stay the same with the new system. Assuming adequate bandwidth and a well designed data model, are there any common performance issues to look out for? Thanks, JoeArticles for your information:
http://www.sql-server-performance.com/merge_replication.asp
http://www.sql-server-performance.com/replication_tuning.asp
http://msdn.microsoft.com/library/en-us/replsql/replperf_5kx1.asp
http://www.databasejournal.com/features/mssql/article.php/1438231 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I’m using it for application with appro 150 users it works great
on T1 for me for replicationg data from San Diego To Boston. -Nilay
]]>