I am trying to use Microsoft Sync Framework 2.1 in a SQL Server database. There will be a large number of concurrent end users synchronizing with the central database server.
Additional specifications:
- 1,500 concurrent clients connect to 1 central database server
- Client uses MS SQL Server Express 2008 R2
- Server uses MS SQL Server Enterprise 2008 R2
- Short sync intervals (about 5 minutes)
- The database size is 5 GB.
- Webservice will be used as a SyncProvider server
Does anyone have any experience with Sync Framework environments like this?
- Is it possible?
- What is important to consider when implementing this?
- What are the physical limits I can expect?