SQL Trace is not writing any data to the DB

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.

All Forums

Other Forums

ClearTrace Support Forum

SQL Trace is not writing any data to the DB

Author

Topic

hgkapadia
Starting Member

1 Post

Posted - 2011-11-11 : 03:08:38

Hi,

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.

--
Harry

tmutch
Starting Member

1 Post

Posted - 2011-12-22 : 16:23:33

Hi

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.

What am I doing wrong?

Tim

Tomás
Starting Member

1 Post

Posted - 2012-06-19 : 11:38:14

Hi Everyone..... I have the same issue........

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.

Please help..!!!!

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2012-06-19 : 17:35:24

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources