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 |
|
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. |
|
|
|
|
|
|
SQL Trace is not writing any data to the DB