Re: run Profiler on a specific SP/Query/Function
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sat, 22 Apr 2006 22:26:15 +0000 (UTC)
Greg Linwood (g_linwood@xxxxxxxxxxx) writes:
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..
Here is another reason to include RPC:Starting event that I just learnt
about, even it is just temporary until SP2 comes out:
http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=b41bc63f-bcb6-4068-a814-24f26bc91ca0
--
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
.
- References:
- Re: run Profiler on a specific SP/Query/Function
- From: Greg Linwood
- Re: run Profiler on a specific SP/Query/Function
- From: Michael Hotek
- Re: run Profiler on a specific SP/Query/Function
- From: Erland Sommarskog
- Re: run Profiler on a specific SP/Query/Function
- From: Greg Linwood
- Re: run Profiler on a specific SP/Query/Function
- Prev by Date: Re: SQL 2005 Flat File source (in Import wizard) missing
- Next by Date: Re: sp_configure 'min server memory (MB)' in SQL 2005
- Previous by thread: Re: run Profiler on a specific SP/Query/Function
- Next by thread: Importing data with BCP using a query...
- Index(es):
Relevant Pages
|
