SS05 Profiler questions

Why does SS05 Profiler create multiple .trc files?  Is this configurable?

If sets of SPs are called to process items (item = row in a table) , is it
possible to configure SS05 Profiler to estimate the time-to-process an item
assuming profiler is not being run ?

Do you mean rollover files?  Can you be more specific as to how you are
using it and how you configured it?  If you use the sp:Completed event you
should get the duration of the sp itself.

--
Andrew J. Kelly  SQL MVP


"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:eOB8syHSGHA.4264@TK2MSFTNGP11.phx.gbl...
> Why does SS05 Profiler create multiple .trc files?  Is this configurable?
>
> If sets of SPs are called to process items (item = row in a table) , is it
> possible to configure SS05 Profiler to estimate the time-to-process an
> item assuming profiler is not being run ?
>

Unfortunately, I know almost nothing about SQL Profiler. I'm assuming the
Duration and Time cols refer to time to execute including the Profiler
overhead.

"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:ejWEWQJSGHA.2176@TK2MSFTNGP10.phx.gbl...
> Do you mean rollover files?  Can you be more specific as to how you are
> using it and how you configured it?  If you use the sp:Completed event you
> should get the duration of the sp itself.
>
> --
> Andrew J. Kelly  SQL MVP
>
>
> "John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
> news:eOB8syHSGHA.4264@TK2MSFTNGP11.phx.gbl... 
>
>

Profiler is a gui tool that runs what is called a Trace behind the scenes
that actually does the work. Profiler just gives you a nice way to display
it. But it can add overhead to a busy server and cause the times to be
somewhat longer than without it running.  But as long as the server is not
too busy it should not be significant enough to worry about for something
like this. If you need the time for an individual statement within the sp
you should use sp:stmtcompleted but be forewarned it can spew a lot of data
if you have lots of lines and makes lots of calls to the sp.

--
Andrew J. Kelly  SQL MVP


"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:OKih2BKSGHA.5908@TK2MSFTNGP10.phx.gbl...
> Unfortunately, I know almost nothing about SQL Profiler. I'm assuming the
> Duration and Time cols refer to time to execute including the Profiler
> overhead.
>
> "Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
> news:ejWEWQJSGHA.2176@TK2MSFTNGP10.phx.gbl... 
>
>