October 28, 2002 at 9:07 am
What is the difference between RPC:Starting and SP:Starting?
The RPC:Starting definition says this is when a remote procedure call has started. So this is just the same stored procedure being "called"? (same meaning whats in SP:Starting)
If this is the case is there any need to include the RPC:Starting if I am using SP:Starting?
Sounds like just redundant data being collected.
October 28, 2002 at 9:55 am
It may be, though they are different event IDs. RPC:11, SP:Starting : 42. Not sure of the technical differnec, though I suppose there could be an RPC that wasn't a stored procedure.
Appears the ODBC and OLE-DB connections involve an RPC, so technically this is a event that occurs before the stored procedure starts.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 29, 2002 at 6:00 am
RPC's show you the call coming into SQL Server. SP's show you all Stored Procs being executed.
For example, if you have a stored procedure called SP1, and this in turn makes a call to SP2.
If you execute SP1 from Query Analyzer and profiler is tracing RPC's only, you will only see the call to SP1.
If you are tracing SP's, you will see the call to SP1 and SP2.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply