locked
Performance concerns for OLTP RRS feed

  • Question

  • The communication between client and server appears to real time.  If numerous clients sync during the same timeframe, what would be the effect to online performance?  Using MSMQ to throttle the concurrent clients does not seem to be an option.  Creating a separate database with SQL Server Replication would be an option.  Are there any other ideas or suggestions to minimize the impact of sync to online users?

    • Moved by Max Wang_1983 Friday, April 22, 2011 10:52 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Friday, May 11, 2007 2:23 PM

All replies

  • It all depends really.
     
    If you expect a large number of concurrent sync'ing clients that might overload the server for local users, you might want to offload some of that load to a second server and use DB replication to keep both in sync.

     

    Friday, May 11, 2007 3:39 PM
  • As Rafik stated, the perfomance realy depends on your scenarios. one of rule is trying to avoid synchronizing clients and dong local changes at the same time ( but sometime this IS a real world scenarios).

     

    what is you scenrio in this case, such as work load, number of clients etc ?

     

    thanks

    yunwen

    Friday, May 11, 2007 4:34 PM
    Moderator