Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
multiple 'Server Synchronization Provider' instances ? (to handle a large amount of concurrent traffic) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Does N-tier architecture support multiple  'Server Synchronization Provider' instances ?

    The multiple  'Server Synchronization Provider' instances would point to a single instance of SQL Server 2005.

    The goal is to scale up to handle a large amount of concurrent traffic.

    I assume the   'Server Synchronization Provider' instances would be sitting behind a firewall and a load balancer.

    Thanks ,

    Peter
    • Moved by Hengzhe Li Friday, April 22, 2011 5:07 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Tuesday, March 24, 2009 4:07 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    that should be supported. However, you need to ensure the sqlconnection object assigned to each syncprovider is new() so they are not sharing the same sqlconnection object.

    thanks
    Yunwen
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, March 25, 2009 10:04 AM
    Moderator