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 |
|
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. |
 |
|
|
|
|
|
Trace File Read Error