I'm using sql server R2 and i've tried to import 1.9 mb trace file to the cleartrace tool. But it did not complete successfully. Below is the summary i got. It says, 0 summary rows saved.
************************************************************ 1 files found in the trace directory Moving files to the Work Directory... Files to process: 1 ( 1.9 MB ) Clearing Target Tables... ************************************************************ Processing: Sql_BU2_trace.trc ************************************************************ Trace Rows Read: 5,101 Saving Lookup Data... Summary Rows Saved: 0 File Process Time (seconds): 0.5 ************************************************************ Saving Lookup Data... Import Time (seconds): 0.5 KB per Second: 3,940 Moving files to the Archive Directory... Done.
I have the same issue using SQL Server 2008 (SP1) and ClearTrace Build 38:
************************************************************ 1 files found in the trace directory Moving files to the Work Directory... Files to process: 1 ( 850 KB ) Clearing Target Tables... ************************************************************ Processing: log_107.trc ************************************************************ Trace Rows Read: 2,588 Saving Lookup Data... Summary Rows Saved: 0 File Process Time (seconds): 0.5 ************************************************************ Saving Lookup Data... Import Time (seconds): 0.5 KB per Second: 1,631 Moving files to the Archive Directory... Done.
1 files found in the trace directory Moving files to the Work Directory... Files to process: 1 ( 20.0 MB ) Clearing Target Tables... ************************************************************ Processing: log_21043.trc ************************************************************ Trace Rows Read: 80,784 Saving Lookup Data... Summary Rows Saved: 0 File Process Time (seconds): 7.8 ************************************************************ Saving Lookup Data... Import Time (seconds): 7.8 KB per Second: 2,611 Moving files to the Archive Directory... Done.
What events do you have in the trace file? Usually this means that the RPC:Completed event or the SQL:BatchCompleted events weren't captured. Can you zip up the trace file and email it to me?
================================================= Creating tomorrow's legacy systems today. One crisis at a time.
SQL Trace is not writing any data to the DB
Posted - 11/11/2011 : 03:08:38
