Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to Server-side Tracing - Step 8: How to Automate SQL Traces using the Data Collector Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 10:37 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, November 23, 2014 7:49 PM
Points: 59, Visits: 307
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
Post #1063680
Posted Wednesday, November 19, 2014 4:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 20, 2014 6:44 AM
Points: 1, Visits: 30
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!
Post #1636543
Posted Sunday, November 23, 2014 7:36 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, November 23, 2014 7:49 PM
Points: 59, Visits: 307
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.
Post #1638399
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse