Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tkizer
Almighty SQL Goddess
38200 Posts |
 Posted - 2009-08-10 : 14:03:41
|
Bill,I ran a two-hour trace late last week and wanted to get quick summary information, so I ran ClearTrace.I imported my trace files (spans two files), but it can't find the TextData column even though it exists. Here is the output from the "Import Status" screen:quote:
Files to process: 2 ( 1,221.0 MB )Clearing Target Tables...************************************************************Processing: 20090805080000_dse_profiler.trc************************************************************The TextData column was not found in this trace file.Trace Rows Read: 2,729,414Saving Lookup Data...Summary Rows Saved: 15File Process Time (seconds): 353.6************************************************************Processing: 20090805080000_dse_profiler_1.trc************************************************************The TextData column was not found in this trace file.Trace Rows Read: 602,336Saving Lookup Data...Summary Rows Saved: 13File Process Time (seconds): 71.7************************************************************Saving Lookup Data...Import Time (seconds): 425.3KB per Second: 2,940Done.
The "Item" column on the "Query the Imported Files" screen says:quote:
{TextData Column Not Found In Trace File}
The trace only includes RPC:Completed events and the default columns were added. I can see the TextData column in the trace file by querying it via ::fn_trace_gettable. I'm running your latest version, 2008.34.Any ideas?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2009-08-10 : 14:14:03
|
| Hmmm. That's interesting. Did it save the stored procedure name at all? ClearTrace may be pulling the ObjectName column in place of the TextData for stored procedures.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-08-10 : 14:30:52
|
| I don't see any stored procedure names, just that error. I just remembered that this wasn't done via SQL Profiler and so I didn't grab the default columns. This was done via sp_trace*. I run traces so often that I forgot this was done via T-SQL. Here's the trace definition:exec sp_trace_setevent @TraceID, 10, 1, @onexec sp_trace_setevent @TraceID, 10, 2, @onexec sp_trace_setevent @TraceID, 10, 3, @onexec sp_trace_setevent @TraceID, 10, 8, @onexec sp_trace_setevent @TraceID, 10, 10, @onexec sp_trace_setevent @TraceID, 10, 11, @onexec sp_trace_setevent @TraceID, 10, 12, @onexec sp_trace_setevent @TraceID, 10, 13, @onexec sp_trace_setevent @TraceID, 10, 14, @onexec sp_trace_setevent @TraceID, 10, 15, @onexec sp_trace_setevent @TraceID, 10, 16, @onexec sp_trace_setevent @TraceID, 10, 17, @onexec sp_trace_setevent @TraceID, 10, 18, @onexec sp_trace_setevent @TraceID, 10, 21, @onexec sp_trace_setevent @TraceID, 10, 25, @onexec sp_trace_setevent @TraceID, 10, 26, @onexec sp_trace_setevent @TraceID, 10, 27, @onexec sp_trace_setevent @TraceID, 10, 48, @onexec sp_trace_setevent @TraceID, 10, 51, @onObjectName isn't included in this definition. Is that a problem? What's the minimum columns that are required to use ClearTrace?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2009-08-10 : 15:34:25
|
| It needs either the ObjectName or TextData to get the stored procedure name. It also needs EventClass, CPU, Reads, Writes, Duration. It really like Endtime but doesn't need it.It likes ApplicationName, LoginName and Host but doesn't need them.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-08-10 : 16:03:03
|
| I'm going to run another trace tonight to see if it'll work this time. I'm going to use SQL Profiler to build the trace script file and then schedule it to run late tonight. I'll let you know tomorrow the results. The trace script file that I used for the trace that didn't work in ClearTrace was created by Microsoft. They have a tool that generates all of the scripts that they'll need to analyze a case. They call it HTA, I believe.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2009-08-10 : 16:23:57
|
| Try using this script: http://www.cleardata.biz/downloads/TraceScripts.zipI built it specifically to create traces for ClearTrace. by default it will create 3 stored procedures. One of them creates a trace. should be pretty easy to modify for what you want.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-08-11 : 13:34:07
|
| Bill,The trace that I ran last night was able to be analyzed by ClearTrace. I compared the T-SQL code between the two trace scripts and there isn't much of a difference at all.I did look at your 3 stored procedures and although I didn't use them for last night's trace, I was very impressed with your code. I'll definitely be using them in the future.Let me know if you are interested in the two trace scripts, I'd be happy to email them to you if you want to figure out why ClearTrace couldn't find the TextData column using the first one even though it is included in the trace definition.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2009-08-11 : 13:43:49
|
| Send them over. I'll take a look when I get a chance.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
The TextData column was not found in this trace fi
I'll email them to you shortly.Tara Kizer