Professional Web Applications Themes

Profiler Question (Stored Procedures) - Microsoft SQL / MS SQL Server

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 for CPU, Reads and Writes (according to BOL this is as it should be). OTOH, the RPC:Completed entry has nothing for the ObjectID while the SP:Completed entry does. Could someone explain the difference between a remote procedure call and a stored procedure? Thanks....

  1. #1

    Default Profiler Question (Stored Procedures)

    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 for
    CPU, Reads and Writes (according to BOL this is as it should be). OTOH, the
    RPC:Completed entry has nothing for the ObjectID while the SP:Completed
    entry does. Could someone explain the difference between a remote procedure
    call and a stored procedure?

    Thanks.


    Amos Soma Guest

  2. #2

    Default RE: Profiler Question (Stored Procedures)

    Hi,

    You may check "Stored Procedures Data Columns" in SQL Server 2000 Books
    Online.

    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.


    Bill Cheng
    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: 209.11.226.82
    | 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
    for
    | CPU, Reads and Writes (according to BOL this is as it should be). OTOH,
    the
    | RPC:Completed entry has nothing for the ObjectID while the SP:Completed
    | entry does. Could someone explain the difference between a remote
    procedure
    | call and a stored procedure?
    |
    | Thanks.
    |
    |
    |

    Bill Guest

Similar Threads

  1. Stored Procedures
    By Anthony M. Davis in forum Coldfusion - Advanced Techniques
    Replies: 28
    Last Post: February 9th, 03:17 PM
  2. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  3. Newbie - Stored Procedures/ASP Question
    By newbie in forum ASP Database
    Replies: 11
    Last Post: February 19th, 06:27 PM
  4. Stored Procedures and 4GL
    By Ahmer Sajjad in forum Informix
    Replies: 1
    Last Post: September 9th, 01:23 PM
  5. Profiler Question (Profiler Message)
    By Brian Moran in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 3rd, 05:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139