How to test if batching works properly? RRS feed

  • Question

  • Hello,

    I´ve some performance problems with synchronizitina  table of 13.000 rows and hope to fix it a bit with using batching.
    I think I´ve implemented batching regarding to the How to on: http://msdn.microsoft.com/en-us/library/bb902828(printer).aspx

    My question is now... What is the easiest way to test if batching really works?
    The SQL System profiler?


    • Moved by Hengzhe Li Friday, April 22, 2011 3:17 AM (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Monday, May 11, 2009 3:02 PM

All replies

  • Well I tried it now with the SQL Profile and it seems that my MS SQL 2005 Stored Procedure for the SelectNewAncor is never called.

    Do I have to do more than adding a SelectNewAnchorCommand and setting the BatchSize > 0 to activate Batching?

    Tuesday, May 12, 2009 8:43 AM