SQL Profiler stored procedures

Code profiling for .NET developers.

Moderator: dom.smith

SQL Profiler stored procedures

Postby Jamie_T » Mon Sep 09, 2013 10:52 am

Hi guys,

When I am looking at a SQL call that is a stored procedure with a parameter, it does not show me the value of the parameter, is this possible ?

Would also be great to see what data is returned but I guess that's asking a little too much!
Jamie_T
 
Posts: 1
Joined: Mon Sep 09, 2013 10:48 am

Postby Chris.Allen » Tue Sep 10, 2013 11:48 am

Sorry- no luck on either. ANTS intercept the raw sql string but only the sql environment (a seperate process) resolves the parameters.

ANTS purely shows you the *timings* . Standard SQL query analyzer is what you want on the other end, sorry again.
Chris.Allen
 
Posts: 594
Joined: Thu Mar 12, 2009 4:17 pm


Return to ANTS Performance Profiler 8

Who is online

Users browsing this forum: No registered users and 0 guests