How can we help you today? How can we help you today?

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

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?
Matthew_Sontum
0

Comments

2 comments

Sort by
  • 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



    Eddie D
    0
  • 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.
    Russell D
    0

Add comment

Please sign in to leave a comment.