You may check "Stored Procedures Data Columns" in SQL Server 2000 Books
RPC:Completed Event Class Type of event recorded = 10.
End Time End time of the RPC.
Duration Duration of the RPC.
CPU Amount of CPU used by the RPC.
Reads Number of page reads issued by the RPC.
Writes Number of page writes issued by the RPC.
Text Data Text of the RPC.
SP:Completed Event Class Type of event recorded = 43.
Nest Level Nesting level of the stored procedure.
End Time End time of the event.
Duration Length of time the stored procedure ran.
Object ID Object ID of the stored procedure.
Object Name Name of the stored procedure found in the cache.
Object Type Type of stored procedure that was called.
Text Data Text of the stored procedure call.
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
| From: "Amos Soma" <com>
| Subject: Profiler Question (Stored Procedures)
| Date: Wed, 9 Jul 2003 15:48:21 -0400
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
| Message-ID: <phx.gbl>
| Newsgroups: microsoft.public.sqlserver.programming
| NNTP-Posting-Host: 188.8.131.52
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.programming:372349
| X-Tomcat-NG: microsoft.public.sqlserver.programming
| I'm confused on the difference between RPC and SP. In a trace I set up, I
| track both RPC:Completed and SP:Completed. When I run an app that makes a
| stored procedure call, there is a RPC:Completed entry and an SP:Completed
| entry for the stored proc. However, the SP:Completed entry has nothing
| CPU, Reads and Writes (according to BOL this is as it should be). OTOH,
| RPC:Completed entry has nothing for the ObjectID while the SP:Completed
| entry does. Could someone explain the difference between a remote
| call and a stored procedure?