locked
How the concurrency is handled using MS Synchronization services? RRS feed

  • Question

  • Hi,

    When i try to do multiple sync ups to a single source, sync is happening sequentially there by taking long time for syncups.

    My problem:

    Sync Started at 1:36

    Reader 1 Completed Sync at 1:38:28 with 100 records modified

    Reader 2 Completed Sync at 1:40:40 with 136 records modified

    Reader 3 Completed Sync at 1:43:00 with 100 records modified

     By analysing the above data, we can find out that the sync is happening sequentially. Since sync operation is taking loks on the data source.

    I am using

    MS SQL Server 2008 as server

    MS SQL  CE compact 3.5 sp1 as Client database

    MS Sync Services v1 for ADO.NET(devices)

    Wednesday, September 23, 2009 4:45 PM

Answers

  • the sync service pretty much let the sql server engine handle all the concurrent decisions or managed the locks on the tables being sync-ed, unless the query on the sync adapter explictly specifies the lock hint. it would be your rows are relatively on the same pages ( or set of pages ) or the lock was escalted to a higher level in your case ?

    besides, is there other component that could serialize the sync operations ?

    BTW, just by reading the time when the sync is performance cannot say 100% the operations are serialized.


    thanks
    Yunwen
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, October 6, 2009 1:19 AM
    Moderator

All replies

  • Hi Jagadeesh,

    When you said "do multiple sync ups to a single source", do you mean to a single destination or from a single source?

    Would you please be more specific on the scenario that you are looking at?

    Thanks,
    Nina
    Wednesday, September 23, 2009 10:13 PM
    Moderator

  • Hi Nina,


    All the readers (Motorola MC9009) are syncing with a single destination, which is MS QL Server 2008 database.
    Thursday, September 24, 2009 4:07 AM
  • the sync service pretty much let the sql server engine handle all the concurrent decisions or managed the locks on the tables being sync-ed, unless the query on the sync adapter explictly specifies the lock hint. it would be your rows are relatively on the same pages ( or set of pages ) or the lock was escalted to a higher level in your case ?

    besides, is there other component that could serialize the sync operations ?

    BTW, just by reading the time when the sync is performance cannot say 100% the operations are serialized.


    thanks
    Yunwen
    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, October 6, 2009 1:19 AM
    Moderator