May 29, 2009 at 2:20 pm
Hello,
first off all I'm a sql server noob. So please excuse me if I say something foolish.
I am trying to measure our sql server's performance by running traces.
I have found a tutorial at:
I am trying to execute the following code from that page:
DECLARE @TraceID int
EXEC CreateTrace
'C:\My SQL Traces\All Procedure Calls',
@OutputTraceID = @TraceID OUT
EXEC AddEvent
@TraceID,
'SP:Starting',
'TextData, StartTime, EndTime, ApplicationName, ClientHostName, DatabaseID'
EXEC AddFilter
@TraceID,
'DatabaseID',
37
EXEC StartTrace
@TraceID
GO
And it's generating the following error:
Msg 2812, Level 16, State 62, Line 3
Could not find stored procedure 'CreateTrace'.
Msg 2812, Level 16, State 62, Line 7
Could not find stored procedure 'AddEvent'.
Msg 2812, Level 16, State 62, Line 12
Could not find stored procedure 'AddFilter'.
Msg 2812, Level 16, State 62, Line 17
Could not find stored procedure 'StartTrace'.
Could someone kindly give me a link to a good tutorial? Many thanks in advance.
May 29, 2009 at 2:31 pm
The procs that you're calling (CreateTrace, AddEvent, AddFilter, StartTrace) aren't system stored procs. They code for them should be in that article, if not, the author should have posted them
Check and see if the code for the procs is there, if not, check these out
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 29, 2009 at 2:33 pm
Because I don't know what you've done on that webpage thus far I do have to ask, did you follow that guys deployment instructions before trying to run the script you mentioned?
It looks like you have to download...
http://vyaskn.tripod.com/code/server_side_trace.zip
...and put those files in place before you can run the code you want to run.
If you don't understand the code in those files, I wouldn't run it on a production server. Run it on a test server after you have performed a backup.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply