How do you see the calling parameters / underlying stored procedure for a top SQL Query

Matthew_Sontum

I am new to using the Red Gate SQL Monitoring Tool. The main thing that I need to use it for is to determine the stored procedures in our system that are taking the longest to return (on average) and using up the most CPU time in total.

What is the easiest way to go about doing this?

When it displays the queries in the interface it displays them in parameterized form, so I can't see what parameter values were being passed into the stored procedures.

Where do I see the stored procedure calls themselves?

Eddie D

Hi,
Thank you for your forum post.

Does the information in this help document  provide the information you are
seeking, particularly the 'Analyzing queries' section?  From which you can then review the query details and the query plan?

Many Thanks
Eddie

Russell D

Just to expand on Eddies post, to answer the specifics about parameters, I'm afraid that we don't sample parameters due to the size these would take up in the database. 

You'd have to run this manually whilst running profiling/a trace to capture more data.