Re: run Profiler on a specific SP/Query/Function

From: "Greg Linwood" <g_linwood@xxxxxxxxxxx>
Date: Mon, 17 Apr 2006 10:52:14 +1000

Hi Kevin

If you only want to see external invocations of the stored proc, you can use
the RPC:Starting/Completed & TSQL:BatchStarting / BatchCompleted events with
the same filter. This approach won't suffer the blank Text column issue
you're describing but you only see "external" invocations of the stored
proc.

If you want to see "internal" invocations of the stored proc (eg, where it's
called from within another stored proc), the above approach won't work.

Regards,
Greg Linwood
SQL Server MVP

"kevin" <kwilliams_AINT_NO_FOOL_@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:5AECB9AE-A618-4A34-887E-30A0EB9A259A@xxxxxxxxxxxxxxxx

using SQL SERVER 2K is it possible to filter Profiler to look at a
specific sp.

currently, I am filtering by databasename and loginname and this is pretty
good. I tried to enter % usp_mysp % in the Text but profiler kept
returning
rows with the Text column blank. The sp I am looking for has not begun
executing, so I know that this type of filter is not working.
--
kevin...

Follow-Ups:
- Re: run Profiler on a specific SP/Query/Function
  - From: Michael Hotek

Prev by Date: Re: Exception trying to import data from Excel .
Next by Date: Re: run Profiler on a specific SP/Query/Function
Previous by thread: Re: run Profiler on a specific SP/Query/Function
Next by thread: Re: run Profiler on a specific SP/Query/Function
Index(es):
- Date
- Thread

Relevant Pages

Re: run Profiler on a specific SP/Query/Function
... especially from a performance tuning perspective. ... If you only want to see external invocations of the stored proc, ... so I know that this type of filter is not working. ...
(microsoft.public.sqlserver.tools)
Re: run Profiler on a specific SP/Query/Function
... I find the RPC: Starting and the TSQL:BatchStarting events to be ... If you only want to see external invocations of the stored proc, ... so I know that this type of filter is not working. ...
(microsoft.public.sqlserver.tools)
RE: "too few parameters expected" when filtering OpenRecordset
... the filter line doesn't look right. ... The only solution I know of is to add a column in the query to get the ... into a second recordset and then assign the second recordset to the listbox. ... 'Define the SQL to run the stored proc ...
(microsoft.public.access.modulesdaovba)
RE: SQL Server 2000 Profiler
... You should choose to capture the event class SP:Completed and set your filter to limit only those procedures with duration> 100. ... > filter only stored proc that have taken ...
(microsoft.public.sqlserver.tools)