Stairway to Server-side Tracing - Step 8: How to Automate SQL Traces using the Data Collector

• Dan Guzman

  SSCommitted

  Points: 1506

  More actions

  February 14, 2011 at 10:37 am

  #234949

  Comments posted to this topic are about the item Stairway to Server-side Tracing - Step 8: How to Automate SQL Traces using the Data Collector

• ChrisRDBA

  SSC Rookie

  Points: 49

  More actions

  November 19, 2014 at 4:05 pm

  #1759683

  Greetings Dan. Great article!

  I have a question regarding the output table snapshots.trace_data. Data makes it into this table when the Trace server and MDW servers are the same, but not when they're different. The jobs run without error, etc. but data simply never arrives. I ran a trace on the MDW server to see if anything was happening during the collection/ load phase and there is some activity related to these, but not the actual load.

  Any ideas?

  Thanks!

• Dan Guzman

  SSCommitted

  Points: 1506

  More actions

  November 23, 2014 at 7:37 pm

  #1760394

  For starters, check the execution log in the MDW database for the problem collection set to see if any issues are logged:

  SELECT *

  FROM syscollector_execution_log

  WHERE collection_set_id = <specify-collection_set_id-here>

  ORDER BY finish_time;

  You can find additional details about Data Collector logging at http://technet.microsoft.com/en-us/library/bb677224(v=sql.105).aspx.

  Hope this helps.