How to capture executing of inner SPs using profiler

#1

Hi,

Currently, i know that i can capture SP that executing from code or
from SQL Managmtnt studio. bit if a specific SP executing another SP i
don't see that in the profiler.

Any idea how can i see that?

#2

omtechguy (omtechguy (AT) gmail (DOT) com) writes:

Quote:

Currently, i know that i can capture SP that executing from code or
from SQL Managmtnt studio. bit if a specific SP executing another SP i
don't see that in the profiler.

Any idea how can i see that?

You need to add the events SP:SPStarting and SP:SPCompleted to you
trace.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to capture executing of inner SPs using profiler

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

How to capture executing of inner SPs using profiler - 02-15-2011 , 03:44 AM

Re: How to capture executing of inner SPs using profiler - 02-15-2011 , 04:31 PM