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.


  1. Allow Groups to be created on Instance name rather than server name

    For multiple instance hosts, each instance can have a separate functional purpose. However groups do not allow instance level granularity. It would be useful to have distinct instances from the same host in separate groups.

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Add option(s) for manual purging of data (use case: removed instances, deleted databases)

    CONTEXT: When you remove a machine from monitoring in SQL Monitor / delete a database from an instance / rename a database... - data stays in the SQL Monitor database (e.g. machine/instance/database is still visible on the Analysis tab), at least until relevant monitoring data is purged.

    PROBLEM: If you have some purge settings set to "do not purge", that data never goes away. Sometimes that is OK (you want the history retained), sometimes it's not (bloats the SQL Monitor database, unneeded entries on the Analysis page...).

    EXAMPLE SOLUTIONS:
    Add options to manually (on demand) delete data for a chosen…

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Add option to make Reports public - i.e. available without having to log in

    ..so that i can add a publicly (internally..) available all-in-one dashboard view to my NOC TV screens, presenting all relevant information at a glance!

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. SQL Monitor self update (or one click update)

    Instead of downloading and running a wizard, I would like to see a way for SQL Monitor to self update, or to have a 'one click' update button built in the interface.

    26 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  ·  Flag idea as inappropriate…  ·  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. I wish the blocking Process report included the resource the Blocked processes are waiting on.

    My Dev write 500+ line procedures and functions so the SQL "Fragment" is seldom very helpful.
    It would be much more helpful to identify the resources the processes are blocked on. Even just the waitresource and waittype columns from sys.dmexecrequests would help.

    I know some of the resource types are tough to parse in T-SQL.

    26 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Trigger Self Healing Script and Auto Close

    It would be great if SQL Monitor could invoke a SQL script upon an alert threshold being crossed and then take action within itself (ie. clear itself, notify a team, etc) based on the value returned (0/1) or default to an action if there is an issue with the script execution.

    This type of functionality would help administrators have a first line of defense before truly getting paged on an alert such as a drive filling (perhaps you have txt files you can purge or shrink logs (though I don't necessarily condone this, but you get the idea!)

    25 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  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Find Queries / Stored Procs whose Performance has Decreased Over Time

    In preparation for changing the database compatibility level for our primary database to 2014, we would like to see which queries and stored procedures are performing poorly after the switch is made in the staging environment. While I can do this to a limited extent by looking at top queries in Red Gate Monitoring, I was wondering if there was an automated way to alert on this. For example, alert on any stored procedures / queries that appear in the top 100 costliest queries by duration / CPU usage, whose average duration / CPU usage has more than doubled since…

    25 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  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. See on the overview page incase of a AlwaysOn or a windows cluster which node is the active\primary

    We have several windows clusters and AlwaysOn clusters. It would be very helpful to see on the overview page which node is active.

    It can be easily done by adding a color to the AG icon on the tile.

    I know that it can be seen on the cluster overview but I really think it belongs on the Overview page.

    25 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  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Utilize SQL (or SQL-like) statements in filters.

    Utilize SQL (or SQL-like) statements in the filters, specifically on the Overview tab to filter on server name. For example: '%sql%' AND '%prod%'
    Currently you can only do 1 fuzzy logic search. Also, you cannot search just by one character.

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  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. Configurable time for fragmented indexes alert run

    I would like an GUI option to configure the time the alert fragmented indexes run instead of it being set at 1.00am Sunday morning

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Daniel Rothig responded

    Note that this can set in the BaseMonitor .config file

  11. Add custom metrics to Overview(s)

    Add the ability to choose what is displayed on the overview for a given server/instance - especially with the addition of custom metrics.

    Even better would be to allow the addition of multiple overviews (aka Dashboards) and configure what each one displays.

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Daniel Rothig responded

    We like that idea – if it gains traction, we’ll prioritise it more

  12. Configure Data Purge by Server/Instance or at least by Server group.

    I would like to keep production server performance data for a month or more but the dev server data can be purged after a couple of weeks.

    24 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  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. Add Single Sign-On (SSO).

    We would love to have Single Sign-On added so we can use CAS for authentication. This feature would really help make things easier even more so then LDAP/NTLM even... I know I been on a support ticket for weeks to have a "work around" be the answer.

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  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. Long Running Query Duration for Specific Queries

    It would be really useful is this feature came into Live!

    We have a number of queries that run on our SQL servers. We are aware these normally run for a long period of time (5-10 minutes) and do not want to exclude these from being alerted to us. Rather than changing the Long Running Query threshold for all the queries within the server we would like to be able to do it for these specific queries that take that little bit longer than others.

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  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. Notification Profiles

    It would be nice to have different notification profiles. For example, I'd like to have a notification profile for business hours vs. after hours.
    For business hours, I'd like to be notified when certain alerts happen, but during after hours, I would only like to know about if there is a system down issues.

    It would be nice to have some kind of alert escalation system like this. So if I want certain alerts to alert me only when the High threshold has been reached after hours, but any other alerts during business hours.

    23 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  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Support for showing multiple metrics with the same units on Analysis Graph

    When showing more than one metric on a graph on the Analysis page, I fully understand that it is difficult to merge the units scales on the x axis. So what you get is each graph has it's 'own' x axis - and I get that - it makes sense when the units are incompatible (eg. percentage vs KB used vs batch/sec).

    But when all the metrics are measure in the same units, it can create a visually confusing graph.

    For example I'm looking at memory usage over time, so I've chosen Machine: memory used, SQL Server: total memory, SQL…

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  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. Re-fire alert notification if alert stays active

    My initial problem was that an alert that was still active was marked as cleared, but I wanted the alert to 're-appear' as essentially it hadn't been fixed.

    This then led me to thinking about any alerts that can move from Active to Ended. It would be useful to configure these is such a way that if they stay Active for a given period, then they re-fire. I understand that is what the multiple thresholds can be used for (especially if the thresholds define time periods) but in this case I may already be at High, there is no further…

    23 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  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Exclude offline databases from backup alerts

    Exclude all offline data bases from the overdue backup alert as we do not have a need to backup an offline data base. For us if a data base is taken offline it's most likely because its been migrated to another server or no longer needed and will eventually be deleted.

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. SQL Monitor Audit Trail

    It would be nice to have an audit trail of changes in SQL Monitor. For example, if an alert is changed, a new instances is added/removed, or users are added or removed.

    23 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  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Enable Multi-Factor Authentication for login screen

    MFA is rapidly becoming a security standard. Redgate provides a map of the entire companies estate - which would be interesting to an attacker, it would be good if security could be tightened on that login process.

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base