In SQL Monitor, I want to...

Link executions of top 10 queries

I had an issue with a query that runs slow every other day. For a specific slow day I could find it in the top 10 queries. I'd like to be able to easily compare the days when it was previously executed . I did manage this by opening a new tab to select the fast day - the query was hard to find as there were many other queries in the top 10 on the fast day. I'd like to be able to lock in on a specific query and monitor the server/query stats at the time/duration of previous executions. As I said we can kind of do this now by manually searching for the query on other days but it's not always easy when there is a busy workload going on.

5 votes
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Lee Hawthorn shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Thank you for this suggestion. A graph showing a query’s history was added to the Server Overview Top Queries table in Version 7.1.11 in November 2017. This allows you to see a query’s performance over time, view its execution count, duration, reads, and writes, and the points in time a query’s plan changed.

We will close this suggestion, but please do raise another suggestion if you have other specific improvements you’d like to see.

Kind regards,
Adam
SQL Monitor Development Team

0 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base