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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Erland

I'm always keen to learn new Profiler tehniques - how do the Starting events
help you get a better grip over the flow?

Do Starting events let you know if a batch is aborted due to an error any
more than Completed events? I would've thought that collecting an error
event would've been the way to detect those conditions..

Regards,
Greg Linwood
SQL Server MVP

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns97A8672301477Yazorman@xxxxxxxxxxxx
Michael Hotek (mike@xxxxxxxxxxxxxxxxxxxxxxxx) writes:
Also, I find the RPC: Starting and the TSQL:BatchStarting events to be
virtually worthless and never use them. I always use the RPC: Completed
and TSQL: BatchCompleted events, because you get duration, reads,
writes, and CPU which are critical stats when trying to analyze
anything.

Depends. The Starting events can be useful if you want to see how things
interact, so you get a better grip over the flow. Also, I have a feeling
that you don't always get a Completed event if the batch is aborted due to
an error. (But I have not examined this in detail.)

But I far more often exclude them than include them in traces, that's
true.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: VB6/SQl Server 2000 (Vaughn)
    ... exec @errorcode = proc1; ... Hitchhiker's Guide to Visual Studio and SQL Server ... In short, I want to trace the path,of the flow of events, at the server ... and then tried using GetClipStringfunction of the resultset. ...
    (microsoft.public.vb.database)
  • Re: VB6/SQl Server 2000
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... In short, I want to trace the path,of the flow of events, at the server ... I tried by connecting the first SP (from wher I want the trace to start) to ... and then tried using GetClipStringfunction of the resultset. ...
    (microsoft.public.vb.database)
  • Forced to use Table.Rows(...).EndEdit when using data binding
    ... A data adapter is used to manage the flow of data between SQL server ... method fail to write the changes to the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Push or Pull for Replication-Based failover
    ... of the distribution agent. ... I think you're mixing PUSH/PULL with the flow of ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Sum Accumulating Data
    ... Tom Moreau writes: ... But it's difficult when sucaba.r does not really seem to have a grip ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)