locked
Sync does not fire bulk updates during batching RRS feed

  • Question

  • I have enabled the bulk stored procedures and also setup batching. However there are quite a few problems;

    1. The sync is extremely slow for just 600KB of data taking about 5mins.

    2. The update bulk stored procedures are never invoked. They always seem to update one-by-one. This is impeding the performance since we are on a satellite network with a huge latency

    3. We are experiencing locking on certain tables. We have enabled Allow_snapshot_isolation and also used the sp_tableoption to turn off "table lock on bulk"

    Please suggest how we can improve the sync throughput and achieve concurrency of 30+ users trying to sync to the central server in a Hub-And-Spoke topology

    Thursday, August 7, 2014 5:46 AM

All replies

  • you might want to enable Sync Fx tracing in verbose mode so you know what's happening underneath...
    Thursday, August 7, 2014 6:28 AM
  • Thanks for the response June. We are enabling the sync tracing and shall post few more things on this issue. However, using the sql profiler, we see that there is table level locks established on couple of the tracking tables. And it is not clear why the bulk updates are not fired even when the batching is enabled. The biggest problem is the throughput on the low latency network. Are there any performance benchmarks available for sync framework?
    Thursday, August 7, 2014 7:49 PM