<div>
Thanks that's great - I can ow see my store dprocedure calls but the duration box is empty. &nbsp;I only get a<br />
durtaion for the BatchCompleted event. &nbsp;Is there any way to see how long each stored procedure took to run?<br />
<br />
Thanks<br />
Sam
</div>


Thanks that's great - I can ow see my store dprocedure calls but the duration box is empty.  I only get a
durtaion for the BatchCompleted event.  Is there any way to see how long each stored procedure took to run?

Thanks
Sam

<div>
RPC:Completed<br />
SP:Completed <br />
SP:StmtCompleted<br />
SQL:StmtCompleted<br />
<br />
above event should capture duration for you procedure.<br />
<br />
lets Tell me how you are executing your procedure with SQL Server(SQL Analyzer) or any application (ADO.NET)???<br />
<br />
may be i can guide you better.:)<br />
<br />
<br />
<br />

</div>


RPC:Completed
SP:Completed
SP:StmtCompleted
SQL:StmtCompleted

above event should capture duration for you procedure.

lets Tell me how you are executing your procedure with SQL Server(SQL Analyzer) or any application (ADO.NET)???

may be i can guide you better.:)





<div>
<div class="content wysiwyg-content">
I am monitoring a stored procedure that makes several subprocedure calls but my trace only gives me details of the duration of the top level procedure and nothing about the statements and subprocedure calls made within it.<br />
<br />
Can I setup SQL Profiler to also show me information for the calls within the top level stored procedure as well so that I can see which statement it is hanging on?<br />
<br />
Many thanks<br />
Sam<br />
<br />
Sam
</div>
</div>


I am monitoring a stored procedure that makes several subprocedure calls but my trace only gives me details of the duration of the top level procedure and nothing about the statements and subprocedure calls made within it.

Can I setup SQL Profiler to also show me information for the calls within the top level stored procedure as well so that I can see which statement it is hanging on?

Many thanks
Sam

Sam

How to get SQl Profiler so show me subprocedure calls as well

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.