Trace Data collector - Duplicate data in snapshots.trace_data - by Brian Callaghan

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 758038 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/13/2012 6:49:52 PM
Access Restriction Public


We have configured a trace data collector from a script generated by profiler
We have been seeing duplicate entries in snapshots.trace_data each with its own snapshot_id. 
After checking the SSIS package SqlTraceUpload.dtsx and performing a profiler trace on the MDW database we noitced 2 calls were made to snapshots.sp_trace_update_info for each trace collector configured, per iteration . On the second call when there was an event count of 0 we also saw the last_event_sequence was 0. This figure was written to [snapshots].[trace_info]
Sign in to post a comment.
Posted by Microsoft on 8/14/2012 at 10:22 AM
Thanks for reporting this issue. We shall look into this issue and getback

Sethu Srinivasan {MSFT]