SQL Server Performance

Trace Nested stored-procedure

Discussion in 'General Developer Questions' started by DB King, Feb 24, 2006.

  1. DB King New Member


    What would I see if I placed a trace on a set of nested stored procedures ? I have looked on the web any information, but haven't found anything. Any MS urls would be handy.

  2. Adriaan New Member

    Why don't you place a trace on a set of nested procedures, and find out?
  3. DB King New Member

    There must be someone who know what MS have said. Its easier than using trial and error.
  4. Adriaan New Member

    What error?[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Sorry for feeling a bit flippant on a Friday afternoon ...
  5. DB King New Member


    Seriously, Does any1 know what Profiler will do when running nested Stored procedures !?
  6. Adriaan New Member

    As far as I can see, a profiler trace records certain details surrounding executed instructions as they are happening. I can see how the results from a trace on nested procedures may be more difficult to interpret, but I wouldn't know how it would be in any way different from a trace filtered for a single procedure.
  7. joechang New Member

    if you trace Stored Procedures->SP:Completed, it shows called procedure, plus each nested stored proc, where you expecting something else?

    and if you add the column NestLevel, a prize to anyone who can guess what that might show, honorable mention in the Darwin award?

    have you ever heard the phrase: the burned hand teaches best,
    it might be easier to ask, but how much will you learn
  8. DB King New Member

    point taken and thanks.

Share This Page