How do you see the calling parameters / underlying stored procedure for a top SQL Query
Matthew_Sontum
Posts: 26 Bronze 1
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?
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
You'd have to run this manually whilst running profiling/a trace to capture more data.