|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SS05 Profiler questionsWhy 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 Show quote "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. Show quote "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.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... >> 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 ? >> > > 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 Show quote "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@shadhawk.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... >>> 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 ? >>> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics