Profiler Events - 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

SQL Server 2000 Forums

SQL Server Administration (2000)

Profiler Events

Author

Topic

Da_Retina
Posting Yak Master

109 Posts

Posted - 2002-03-17 : 03:14:17

Salute..
It is written in the sql server profiler (I have ver 7.0 sp3) that I can monitor the following events:
Event class Description
SP:CacheHit Procedure is found in the cache.
SP:CacheInsert Item is inserted into the procedure cache.
SP:CacheMiss Stored procedure is not found in the procedure cache.
SP:CacheRemove Item has been removed from the procedure cache.
SP:Completed Stored procedure has completed.
SP:ExecContextHit Execution version of a stored procedure has been found in the cache.
SP:Recompile Stored procedure has been recompiled.
SP:Starting Stored procedure has started.
SP:StmtCompleted Statement within a stored procedure has completed.
SP:StmtStarting Statement within a stored procedure has started.
BUT when I edit the trace's setting I find ONLY The following events..
SP:Starting
SP:Completed
SP:StmtStarting
SP:StmtCompleted
WHERE ARE THE OTHERS?...
Thanks In Advance ppl..
Salute..

------------------
If I am to do it,
I will, and NOW ..

nr
SQLTeam MVY

12543 Posts

Posted - 2002-03-17 : 09:00:41

Have you included the events in the trace?

running

create procedure #sp as select 1

I get
cache miss
cache miss
cache insert
starting
stmntstarting
stmtcompleted
completed

second run
execcontexthit
starting
stmntstarting
stmtcompleted
completed

==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.

Da_Retina
Posting Yak Master

109 Posts

Posted - 2002-03-17 : 10:00:12

Salute..
When I ran your test #sp i found only
SP:Starting
SP:StmtStarting
SP:StmtCompleted
SP:Completed
The other events DOES NOT EXIST in the event list in the trace editor!
,that is, I can not find them to add them!!.
TIA

------------------
If I am to do it,
I will, and NOW ..

Nazim
A custom title

1408 Posts

Posted - 2002-03-17 : 10:06:57

Check the Events property and check the events you have set your tracing on.

HTH

--------------------------------------------------------------

Da_Retina
Posting Yak Master

109 Posts

Posted - 2002-03-17 : 10:30:29

Nazim..
This is exactly what I can NOT find!..the events in the EVENTS properties in the TRACE editing screen DOES NOT have the other events I mentioned!..
Under the stored procedures in the "Available Events" there are only 4 events to add!!..nothing more!
Thanks Again..

------------------
If I am to do it,
I will, and NOW ..

Nazim
A custom title

1408 Posts

Posted - 2002-03-17 : 10:35:22

Am not sure but think it might be permission issues.

try logging in as SA if you can , and check Events properties.

--------------------------------------------------------------

Edited by - Nazim on 03/17/2002 10:36:25

Da_Retina
Posting Yak Master

109 Posts

Posted - 2002-03-17 : 17:23:21

Nazim..
Thanks again..
I am already logged on as SA..
strange huh?

------------------
If I am to do it,
I will, and NOW ..

Nazim
A custom title

1408 Posts

Posted - 2002-03-17 : 23:21:45

Am running out of ideas,

try creating a new trace and check Events (to see if they are listed properly) .

Check with Filters Tab too there you will find a Option Exclude System ID's . check to see if it is already selected if it then unselect it.

HTH

--------------------------------------------------------------

Da_Retina
Posting Yak Master

109 Posts

Posted - 2002-03-18 : 02:47:39

well Nazim..I am thankful buddy!..
but I am running from ideas!...

Ideas that suggests that something buggy is taking place!..
I mean I know how to use the profiler!..I am not new to this business!!..
the events that I told u about just doesnt exist!!!...
By the way!!..TO ALL OF U FRIENDS
How about posting or linking to SCREENSHOT pics!..it might help when ppl demonstrate their problems,well,sometimes at least!!..
I will suggest this in the general SQL section too!..
well thanks again Nazim..if something comes across ur mind..pss me a note here!!.

------------------
If I am to do it,
I will, and NOW ..

Teroman
Posting Yak Master

115 Posts

Posted - 2002-03-18 : 04:37:15

Go to

Tool -> Options

on the general tab change from Common trace classes to All trace classes, then they should magically appear!

col

Da_Retina
Posting Yak Master

109 Posts

Posted - 2002-03-18 : 05:31:13

THANKS ALOT!..
Now..between U and me...was that too easy?..