How do you use cloud databases? Take the survey.

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

Matthew_SontumMatthew_Sontum Posts: 26 Bronze 1
edited October 12, 2018 7:24PM in SQL Monitor
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?
Tagged:

Answers

  • Eddie DEddie D Posts: 1,733 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • 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.
    Have you visited our Help Centre?
Sign In or Register to comment.