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.


2
0
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

Description

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
Brian,
Thanks for reporting this issue. We shall look into this issue and getback

Thanks
Sethu Srinivasan {MSFT]