Trace File Read Error - SQL Server Forums

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

Trace File Read Error

Author

Topic

sgupta
Starting Member

1 Post

Posted - 2009-07-24 : 16:16:22

Hi,
I just installed Clear Trace and created the stored procs.
I was able to successfully execute the create and stop trace stored procs.
However while trying to import the trace file I got the following error.
I will appreciate if someone can help me find a solution to this? I am not a DBA nor I have expert SQL knowledge but can work with suggestions that you can make.

Trace File Read Error in C:\PerfLogs\TESTTRACE_D20090724_Z150243.trc (Exception has been thrown by the target of an invocation.)

Here are the stored proc execution sql...
DECLARE @RC int
DECLARE @Directory nvarchar(1000)
DECLARE @FileName nvarchar(1000)
DECLARE @TraceMinutes int
DECLARE @IncludeTimeStamp bit
DECLARE @MaxFileSize bigint
DECLARE @MinCPU int
DECLARE @MinReads bigint
DECLARE @MinDuration bigint
DECLARE @MinWrites bigint

-- SET PARAMETER VALUES
SET @Directory = 'C:\PerfLogs'
SET @FileName = 'TESTTRACE'
SET @TraceMinutes = '1'
SET @IncludeTimeStamp = '1'
SET @MaxFileSize = '1000'
SET @MinCPU = '10'
SET @MinReads = '1'
SET @MinDuration = '10'
SET @MinWrites = '1'

-- TODO: Set parameter values here.

EXECUTE @RC = [TestTrace].[dbo].[admin_trace_start]
@Directory
,@FileName
,@TraceMinutes
,@IncludeTimeStamp
,@MaxFileSize
,@MinCPU
,@MinReads
,@MinDuration
,@MinWrites

-- Thanks
SG

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2009-07-25 : 10:05:33

There should be a log file written in the same directory as ClearTrace.EXE. Can you post the contents of that?

=================================================
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