Workflow Tracking Events Not Available Until Workflow Completes
I was using Workflow Foundation as part of an internal process recently and I couldn’t work out why the tracking events generated by the SqlTrackingService weren’t being written to the tracking database until the workflow completed or was terminated.
The issue was that the SqlTrackingService is transactional by default and the transaction isn’t committed until the workflow completes or is terminated. This can be changed by setting the IsTransactional property to False before adding the service to the WorkflowRuntime’s services collection.
http://msmvps.com/blogs/theproblemsolver/archive/2006/09/28/Tracking-in-Workflow-Foundation.aspx
