Profiler: Filter SPs and SPs within it.

• SqlServerPass

  SSCommitted

  Points: 1709

  More actions

  June 23, 2012 at 2:46 am

  #262769

  Hi All,

  I need to filter the SPs and the SPs called within it ONLY.

  i am seeing "SQLProfilerTSQL_SPs" template, but this gives all stmts within the SP.

  i need my profiler to list like:

  SP1

  SP11

  SP12

  SP2

  SP21

  SP22

  Appreciating your help always.

• SqlServerPass

  SSCommitted

  Points: 1709

  More actions

  June 24, 2012 at 2:35 am

  #1504804

  SQL Mad Rafi (6/23/2012)

  ---

  Hi All,

  I need to filter the SPs and the SPs called within it ONLY.

  i am seeing "SQLProfilerTSQL_SPs" template, but this gives all stmts within the SP.

  i need my profiler to list like:

  SP1

  SP11

  SP12

  SP2

  SP21

  SP22

  Appreciating your help always.

  Dear All,

  Am i not clear !

  Surprising for first time, no one put their comment .

  Thanks.

• Mohammed Yousuf

  Say Hey Kid

  Points: 696

  More actions

  June 24, 2012 at 5:37 am

  #1504807

  It's a SunDay!!

  1) select New trace with <blank> template

  2) Goto "Events Selection" tab -> Expand node "Stored Procedures" -> Select event "SP:Completed"

  3) Select the columns you need in the trace and hit RUN

  I hope this is "what you asked for"