none
How to synchronize only specific changes in tables in one transaction using SyncOrchestrator and SqlSyncProvider

    Question

  • how to do we sync only changed table instead of syncing entire table even though if are not done any changes.
    Tuesday, October 08, 2013 9:14 AM

All replies

  • not sure what you're encountering, but the way Sync Fx work is it will do incremental syncs, meaning it should only be synching the changes, not the entire table everytime.
    Wednesday, October 09, 2013 2:21 AM
  • Hi JuneT,

    I am facing very bad performance issues in production,

    while synchronizing 4333 records to SQL Server 2008 r2 sp1, its taking around 4 minutes for Upload and 2 minutes for download in VPN connection.

    but i have very less table to synchronize around 28 tables.

    Instead of using Microsoft Synchronization SyncOrchestrator if i write normal SQL Insert and Update query its very faster.

    pls suggest me.

    thanks & regards

    Nagaraj L

    Wednesday, October 09, 2013 6:11 AM
  • have you profiled to determine which part is slow?

    you can easily enable Sync Framework Tracing to trace the sync part.

    Wednesday, October 09, 2013 6:27 AM
  • for inserting the each and every records its taking 1 miliseconds, pls find the trace log

    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:000,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 9238cfe9-b60b-4e32-9966-035da4693440 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:000,          UV: 0,1261533 CV: 0,1261533
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:001,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 2969 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:001,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = f00bcfac-6e78-4209-b273-0371a9b3b81b on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:002,          UV: 0,1261227 CV: 0,1261227
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:002,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 3235 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:003,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = a0fab969-00f3-4f7c-8c73-064d54f4094a on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:003,          UV: 0,1261191 CV: 0,1261191
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:004,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 3561 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:005,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 0bc507f0-9f1a-4fed-90bd-06afee224b1a on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:005,          UV: 0,1261314 CV: 0,1261314
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:006,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 3861 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:006,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 50586b27-35ce-4af8-b37b-07c420bd69db on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:007,          UV: 0,1261407 CV: 0,1261407
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:007,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 4279 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:007,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 2355cce7-bf8a-47da-bd12-094fa3ad2865 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:008,          UV: 0,1261161 CV: 0,1261161
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:008,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 4527 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:009,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 30d2b05d-2f25-421d-acec-0af52f2590ba on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:009,          UV: 0,1261233 CV: 0,1261233
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:010,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 4931 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:010,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = a86ef01f-407d-427f-ac30-0be92a7a8cc0 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:010,          UV: 0,1261494 CV: 0,1261494
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:011,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 5173 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:011,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = bc4da43e-2537-493d-b833-0c0420a8c0f0 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:012,          UV: 0,1261710 CV: 0,1261710
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:012,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 5411 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:013,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 76b55559-fa97-4185-8c6e-0c164f093e3a on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:013,          UV: 0,1261095 CV: 0,1261095
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:014,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 5723 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:014,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 40d86442-8e12-4d33-bb6a-0de5b23c5880 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:014,          UV: 0,1261080 CV: 0,1261080
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:015,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 6033 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:015,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = dc7f9a24-ae37-435d-b6c0-0e7cba9eae22 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:016,          UV: 0,1261272 CV: 0,1261272
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:016,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 6385 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:017,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 8cd86232-db9c-4d02-9650-0f41f067b0c0 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:017,          UV: 0,1261068 CV: 0,1261068
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:018,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 6819 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:018,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 4cae5618-4e66-4d7a-a0c3-0f6d2aad8c52 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:019,          UV: 0,1261659 CV: 0,1261659
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:019,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 7063 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:019,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = cabde5f4-8aac-48f6-81c6-0fadda624ddc on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:020,          UV: 0,1261770 CV: 0,1261770
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:020,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 7807 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:021,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 82b93f63-cce2-4eec-a452-0fdbc1927f13 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:021,          UV: 0,1261131 CV: 0,1261131
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:022,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 8243 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:022,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = bc61b6ab-1ff4-44a9-8748-109b4f16da1c on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:023,          UV: 0,1261089 CV: 0,1261089
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:023,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 8559 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:024,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 37786c3d-1443-445b-a4a4-111222c7559a on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:024,          UV: 0,1261686 CV: 0,1261686
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:024,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 8797 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:025,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 575a725f-68bc-484c-b972-11423c91a51d on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:026,          UV: 0,1261482 CV: 0,1261482
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:026,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 9071 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:027,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = 1f0d0faa-d68c-4ba6-ad21-1170738358b8 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:027,          UV: 0,1261473 CV: 0,1261473
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:028,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 9313 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:028,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = a91fbb28-eb6b-4908-9fe7-117ec82c66c0 on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:029,          UV: 0,1261539 CV: 0,1261539
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:029,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 9553 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:030,       Insert for row with PK: AccountID = ef2df58e-5976-4de3-ac5f-861e12006a54, BranchID = eb9af04f-fbdb-4692-8138-1317d5341ffe on SIMClient
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:030,          UV: 0,1261119 CV: 0,1261119
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:030,       RelationalSyncProvider.BatchedEnum: Memory data cache size after reading row: 9947 Bytes
    VERBOSE, SIM.vshost, 13, 10/09/2013 08:59:18:031,       Insert f

    Wednesday, October 09, 2013 11:54 AM
  • looks like your sync is inserting rows one at a time...did you disable bulk procedures when you provisioned? do you see SPs with the work bulk on them?
    Thursday, October 10, 2013 1:27 AM
  • no i am not disabling the bulk procedures when i provisioned.... please find the log shows the bulk insert command execution.....

    JuneT can u suggest what is minimum sql server configuration in cloud...

    INFO   , SIM.vshost, 9, 10/09/2013 09:01:31:289, Applied 75 of 75 rows with bulk command BulkInsertCommand
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:31:296,    Executing Command: [Requirements_bulkinsert]
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:31:297,       Parameter: @sync_min_timestamp Value: 0
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:31:299,       Parameter: @sync_scope_local_id Value: 21
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:31:300,       Parameter: @changeTable Value: Requirements
    INFO   , SIM.vshost, 9, 10/09/2013 09:01:31:929, Applied 75 of 75 rows with bulk command BulkInsertCommand
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:31:937,    Executing Command: [Requirements_bulkinsert]
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:31:940,       Parameter: @sync_min_timestamp Value: 0
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:31:942,       Parameter: @sync_scope_local_id Value: 21
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:31:944,       Parameter: @changeTable Value: Requirements
    INFO   , SIM.vshost, 9, 10/09/2013 09:01:33:084, Applied 75 of 75 rows with bulk command BulkInsertCommand
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:089,    Executing Command: [Requirements_bulkinsert]
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:091,       Parameter: @sync_min_timestamp Value: 0
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:093,       Parameter: @sync_scope_local_id Value: 21
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:096,       Parameter: @changeTable Value: Requirements
    INFO   , SIM.vshost, 9, 10/09/2013 09:01:33:388, Applied 4 of 4 rows with bulk command BulkInsertCommand
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:405,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ebc5276a-2695-4431-a6a5-6cec63a9d566"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:408,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ebc53c81-078b-4177-969e-49c35c9e9db5"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:411,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ebd97627-5bd3-4d3f-b239-af30daf90b17"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:413,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ebdf729e-b9c1-4e86-a5fb-921ac461e248"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:415,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ebe3ba27-f307-467a-9ac7-43e1dec814f6"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:419,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ebfbd5d8-6177-4f8a-888b-018bf50cf1bb"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:420,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec228cc8-7b16-40bb-bd01-33d0e82e160d"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:422,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec304ac7-9a95-4177-9afa-d1f653bee209"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:425,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec3083c7-8781-4814-baa1-0e9dad5cf968"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:427,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec379f5b-52d9-42d4-86bd-3b4fe2ce3116"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:429,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec38dfc8-e10c-40a6-91ff-82bcfbad0e30"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:429,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec4f9969-13a6-4196-8ba7-d934122010b3"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:431,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec5f1ff7-7289-46df-92ec-104fc515fd94"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:433,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec6258f5-8978-4aca-ae3a-90a2b93b123f"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:434,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ec9eefcb-52fc-49c0-8d52-a69dc850bef3"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:435,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ecea9b38-d0d6-4652-ab16-1d011835b8ae"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:435,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ecf0cc11-084e-4fa0-a935-1153e9e5dc12"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:436,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ed1298a9-c837-4c6f-9ec7-cb46095385c6"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:437,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ed266e13-fa08-49e7-a8d4-68b5cea545d9"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:439,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ed70cd4e-22a3-491e-b580-e3b55fc055c2"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:440,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="edb2cda3-7eb3-42b6-9184-31f921351d9a"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:441,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="edbc8a2b-6a80-4e6e-9000-f896e449e679"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:442,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="edcf05fe-d051-4cb1-bd77-c31f2392de98"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:443,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="edee82bf-12a8-4169-b3df-7ffe15631b5f"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:444,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="edf5ab88-7b61-4f38-a532-02d06d0e5cfb"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:445,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="edfa6eac-e66e-4f21-b337-0be0167a0315"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:446,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ee3ba894-32dc-434f-ad6d-b1e8cb1ca0b1"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:449,    Inserted row with PK using bulk apply: AccountID="ef2df58e-5976-4de3-ac5f-861e12006a54" WorksheetID="858a034d-7ac4-4e78-9331-51ecd60f1acf" RequirementID="ee543ed8-0489-4118-b680-63e31f4053af"  on SIMServer
    VERBOSE, SIM.vshost, 9, 10/09/2013 09:01:33:450,   


    • Edited by Nagaraj L Thursday, October 10, 2013 6:58 AM
    Thursday, October 10, 2013 6:37 AM