Note: Please use this only when you see failures in data collector tasks and would like to see more details on the root cause. It is recommended to disable this trace settings after you are done with gathering trace logs
1) Create a folder c:\temp\tracing
2) copy the contents to a file named dcexec.reg
Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLTools\dcexec]"Components"="DCEXEC,TxDataCollector,DataCollectorController,DataCollectorTasks,Microsoft.SqlServer.Management.CollectorTasks.dll""Tracelvl"=dword:fffffff7"Traceloc"=dword:00000003"Prefix"="date,time,pid,tid""LogDir"="c:\\temp\\tracing""LogFileMode"="Unique"
3) Import dcexec.reg file to registry.
4) Start data collector and you would see new trace logs created in c:\temp\tracing
4) Once you are done with gathering tracelogs, delete the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLTools\dcexec
5) If you can email us these trace logs( that were generated when data collector failed), we can work on helping you out. Email to : firstname.lastname@example.org
There is a copy of dcexec.reg.txt file attached to this blog. you can download it, rename it to dcexec.reg and import it to registry
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm