Skip to content

Suggestions

Welcome to the Redgate SQL Monitor feature suggestions list. Tell us how we can improve SQL Monitor by voting on these suggestions or by submitting your own ideas.

This is the easiest way to make an impact on SQL Monitor’s roadmap. Check out the completed suggestions to see how your ideas have influenced us in the past. Please note that this list is one of multiple sources that drive our development, meaning that we will not always implement the highest-ranking suggestions.

To give your idea the greatest possible impact, please follow these guidelines:

  • Describe the goal you’re trying to accomplish, rather than a specific solution to get there
  • If you have a favoured solution, add it as a comment to your suggestion
  • Give us as much context as possible
  • Only make one suggestion per post. If you have multiple ideas, submit them in separate posts
  • Comment and vote on existing posts to develop the ideas — often the SQL Monitor team will initially stay quiet about new suggestions to see what you have to say!

If you have any questions visit the SQL Monitor forum.


180 results found

  1. Custom Metric Order

    Either allow an order to be defined for custom metrics on the analysis tab or at least order them alphabetically rather than in the order created.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    We’ve alphabetically ordered the custom metrics on the Analysis tab and this will go in the next release which we hope to have available later next month.

    Thanks again for the suggestion.

  2. Allow drilldrown capability for different resource areas

    It would be nice to be able to see which sql statements or db users were generating the most CPU usage, RAM usage, and Disk IO. This would help us quickly identify bottlenecks on the system.

    CLR statistics would be nice to have too since we have found that it can account for locking issues in certain circumstances.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Daniel Rothig responded

    Resource utilisation per query can be seen in the top 10 queries view on the SQL Instance overview

  3. When using "Back" browser function PLEASE put me back at the same place in the LONG list!

    Although http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2022999-add-previous-next-navigation-to-alert-details talks about previous/next, buried in it is the problem of wading through PAGES, AGAIN of stuff I've hunted through.

    I'd like to add this separate request to deal with the simple issue of "put me back at the same place in the list as I was when I clicked an Alert to view".

    I should not be forced to clear younger Alerts just so the Alert I'm on appears on page 1, either (not an elegant workaround).

    Thanks.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    We ran a series of usability sessions which included the new work we have completed adding previous/next (well, newer/older) and making filters persist, to understand how we should adapt this.

    Now, when you work through a number of alerts using the newer/older navigation, clicking on the inbox will take you to the inbox at the point you would be – i.e. you will ‘emerge’ at that point. Hopefully this will solve the problem as you will not ‘be forced to clear younger alerts’.

    We hope this solution works for you and we’d be interested to hear how you find the new features.

  4. Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed on SQL Instance overview

    Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Add more information to alert email

    It would be nice to have more information sent into the alert email, instead of having to login into the monitor to check details. I am not sure if there is a way to do this already. If there isn't - this would be nice to have.

    For e.g: This doesn't divulge which query. If the query was mentioned, it would help.

    ID: 59

    SQL Server: (local)
    Machine: (Machine Name)
    Alert type: Long-running query
    Level: None
    Time raised: 8 Mar 2012 12:44 PM (UTC-05)
    Time ended: 8 Mar 2012 12:50 PM (UTC-05)
    View full alert detail

    147 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.

    Thanks,
    SQL Monitor Development Team

  6. add the ability to specify a default filter. I'm getting tired of having to re-select my custom filter each time I click on the Alerts tab.

    When working through a huge list of alerts, if I don't remember to click on the "back" button I am forced to re-select my custom filter from the Filter dropdown list.

    If would save some time if a custom filter could be specified as the default Alerts filter.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    In v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can navigate away and always return to the filtered alerts without having to reselect the filter from the dropdown list.

    We hope this fixes the root of the problem that your workaround was a suggestion for. We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com. Thanks again for the suggestion and comments.

  7. create a function to allow clearing of all alerts on a given server, instance, database.

    Currently i can only find a way to clear 100 alerts at a time, or to purge information from the SQL monitor. It would a nice easy feature to be able to clear all alerts in one go.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. Ability set working hour for analysis graph

    ability set working to compare last x day for only working hour

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Daniel Rothig responded

    You can already do that – just specify what your working hours are in the time selector boxes

  9. Invistigate v3.0 EAP Base Service CPU utilization

    I first installed v2.3 and then switched to v3.0 EAP. It seems that the base service is maxing out CPU utilization which was not the case with 2.3.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. It would be grand if I could change the time format.. 12 hour clocks just don't sit right with me.

    It would be grand if I could change the time format.. 12 hour clocks just don't sit right with me.

    35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    We have just released version 6.0.7 and this update means the clock can now be displayed in either 12 or 24 hour format – this can be toggled at Configuration > Display settings.

    Thanks for your patience.

    SQL Monitor Development Team

  11. Show the database name not just dbid in the Lock Details of a Deadlock alert

    I've got to do the extra step of:

    SELECT name,dbid
    FROM master..sysdatabases

    to figure out which database the deadlock is referring to... shouldn't have to do this.

    71 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    Database name is now shown for 2005+ deadlock alerts following the v4 release.

    Thanks again for the suggestion and votes.

  12. Preserve advanced filter settings when page size is changed

    When viewing alerts and changing page size, a predefined filter setting is preserved, but any other advanced settings appear to be reset.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    In v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can change the page size or navigate away and always return to the filtered alerts without having to reselect the filter.

    We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com.

    Thanks again for the suggestion and comments.

  13. Report average page life expectancy

    The "page life expectancy" performance counter can be a good indicator of an impending performance problem. It's in the "Buffer Manager" performance object.

    http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-%E2%80%93-what-is-page-life-expectancy-ple-counter/

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Make cookie timeout duration configurable

    Currently Cookies expire after 2 days, this means you have to re-enter your password for SQL Monitor every two days. This should be configurable. Some of us have adequate desktop security, and secure external access that this is unnecessary.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Traceflag 1222 for deadlocks

    Use traceflag 1222 for deadlocks when monitoring SQL 2005+, and keep 1204 just for SQL 2000 instances. 1222 gives so much more information and doesn't cut off the SQL text.

    48 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    Hello,

    We are pleased to annouce that this feature is now implemented as part of v4.0 release. Please check release notes for more details.

    Thanks,
    Priya

  16. Put SQL statements from "top 10" in a textarea box

    I'd like to see the SQL statements in the "Top 10 expensive queries" inside a textarea box so it's easy to copy and paste out of it.... The current layout of putting the SQL in a div makes it difficult to get the SQL out of there to paste into Management Studio to examine

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Change colour of chart line

    When viewing a single metric chart in 'Analysis', the line is a yellow-golden colour, which I find horrible (just my opinion) and hard to focus on - can this be configurable?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    This was completed in 3.0 – apologies for not updating sooner.

    We changed the colour palette and improved it. We have still had to use yellow due to the number of dbs it’s possible to display, but it will be used last and is more of a mustard/orange yellow now. We’ve also deepened other colours so the Analysis page should be easier to view.

    We hope this is fixes the problem – thanks for the suggestion – and we welcome any feedback.

  18. Enable and track wait stats

    I would like to see an overview of wait statistics along with historical tracking of those waits. I currently have queries that would show the total wait time, but other tools I have used will provide a current snapshot of these waits as well as store them historically so that I can monitor changes.

    72 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    Hi,

    We are excited to annouce that SQL Monitor v4.0 has been released. This release contains Performance diagnostics features which let you analyze the waits and queries affecting SQL Server performance on the Instance overview and Database overview pages. Check out the release notes for more details.

    Thanks,
    SQL Monitor Development Team

  19. Allow filter on Global Overview

    E.g. exclude 'Ended' (but not yet cleared) alerts. (Gives an overview of the current state)

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Adam responded

    We believe improvements to the dashboard in 5.2 make this no longer valid. Please open a new suggestion if you would like to see further improvements.

  20. Email Alerts subject info

    Change the subject to the email alert, remove the SQL monitor ID number as taking up space without adding value, making it more difficult to gather the neccesary info from the subject line for job failure etc when viewing email through a portable device iPhone etc.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Priya Sinha responded

    SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.

    Thanks,
    SQL Monitor Development Team

  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base