Post reply

Profiler set up to track procs which are called from a parent proc

  • September 14, 2011 at 10:54 pm

    #248083

    Hi The requirement is

    Proc A

    begin

    exec proc B

    end

    I want to see what are the parameters that are being passed to proc b . How to set up the profiler to achieve this ?

  • September 15, 2011 at 5:41 am

    #1381854

    That's one of the tougher ones to set up. You need to capture statement level events. When capturing statement level events, you're going to get lots and lots of data. If possible, set it up so that you turn on the server-side trace (don't use the profiler gui), run the procedure, and then turn the trace back off. If you just turn on capturing statements and walk away, you're going to have lots of information to deal with.

    "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

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

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