February 14, 2011 at 10:37 am
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
November 19, 2014 at 4:05 pm
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!
November 23, 2014 at 7:37 pm
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.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy