Post reply

Profiler: Stored procedure executed successfully but SP:completed and RPC:completed now showing. Why?

  • August 24, 2011 at 10:26 am

    #98389

    HI,

    Edition:SQL 2005 64 Bit

    In profiler, i have selected SP:starting, SP:Completed, RPC:starting and RPC:completed.

    For a .Net call for a procedure, i can see RPC/SP:starting event. Procedure executed successfully but its not showing event of SP/RPC:completed in the profiler.

    Now if i run the same input in SSMS, all above four events shows the relevant info.

    SO which thing is stopping SP:completed and RPC:completed when we get a call from .NET?

    Thanks.

  • August 25, 2011 at 6:49 am

    #1373100

    Did you start a transaction on the client side and is it committed?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 25, 2011 at 10:40 am

    #1373339

    No transaction.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply