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, Joe
Articles 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