Skip to content

Suggestions

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

This is the easiest way to make an impact on Redgate 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 — the Redgate Monitor team will often stay quiet initially about new suggestions to see what you have to say!

If you have any questions visit the Redgate Monitor forum.


728 results found

  1. global dashboard should handle multi-level groupings

    Currently the global dashboard presents the SQL instance tiles according to their top-level group. So if I have 3 servers grouped such as:

    App1

    Prod

    Svr1
    Dev
    Svr2
    App2
    Prod
    Svr3

    it will present these under 2 groups: App1 and App2. This is fine if you're viewing all servers.

    However when I filter the view to only show servers in the App1 group, I'd like the tiles to be grouped using the next level of grouping if there is one (in this case "Prod" and "Dev")

    18 votes
    1 comment  ·  Admin →
    How important is this to you?
  2. Alerts in SERVER Time Zone, NOT Browser!

    Back in June 2016, I added the following to the now-defunct "Previous version" SQL Monitor Forum. The responder said it was in the Q for the next sprint, no promises as to its inclusion. DISAPPOINTMENT/FRUSTRATION continues to be experienced 6 MONTHS later!

    Alerts at SERVER time, NOT UTC! PLEASE!

    For the love of all DBA's with servers in multiple time zones (yes, this happens), for goodness sake STOP emailing the time of the Alert based on the SQL Monitor's Regional Settings.

    In 2016, this statement from the page at https://documentation.red-gate.com/display/SM5/Alerts, is nigh on unbelievable, "All alert times in SQL…

    25 votes
    How important is this to you?
  3. Improved view of User Sessions

    Visibility into user sessions could be improved. The current list on the instance overview, "SQL User Processes (Top 10)", is a start but needs the following to make it useful:

    1) Don't limit the number of sessions shown; rather add paging controls like on the error log view, so that it would be possible to see any session for any selected time period
    2) Add a columns for:
    - Login (i.e. login name)
    - Blocked by session Id (maybe even an icon if a session is blocking/blocked?)
    3) Make it possible to sort by any column
    4) Add ability to…

    13 votes
    How important is this to you?
  4. On the Overview screen, collapse AlwaysOn clusters into a single tile

    I have quite a few AlwaysOn groups, with 3 servers as part of the group. SQL Monitor very cleverly takes the cluster name and adds all 3 servers to the monitoring list ... HOWEVER, on the Overview screen, they show as individual servers. It would be good if I could collapse that all down into one tile that shows an overall health of the group. I realize this is a different situation from an FCI because there can be multiple 'active' nodes, but it would be good if SQL Monitor understood that I added an AG listener server list and…

    6 votes
    How important is this to you?
  5. New tile types in reporting

    We would like new tile types in the reporting interface. Extend the Analysis graph and summary. We would like some of KPI \ traffic light or the ability to just show a single value but be able to colour the background of the tile.

    As well as the analysis graph it would be useful to be able to have a bar\column chart as well as the existing line chart.

    10 votes
    How important is this to you?
  6. Detect Unsupported SQL Server Versions When Upgrading Versions

    I was running v4 with a MSSQL 2005 database and decided to upgrade to v6. The installer finished successfully, however when it took me to the Web App page, there was a warning that the database upgrade did not complete successfully. The reported error was "Cannot assign a default value to a local variable". I knew right away it was a problem with my old SQL Server version. I checked the forums and indeed, 2005 is no longer supported with version 6. I understand that, and have no problem with it. However, ya'll would have saved me the headache of…

    6 votes
    1 comment  ·  Admin →
    How important is this to you?
  7. Select different purge data ranges depening of what group a server belongs to.

    We have different data retention requirements depending on what server is being monitored, but currently only 1 purge setting is available which covers all servers. An example of what I'd like to see would be to select to purge data older than 14 days for production/critical servers and a much shorter retention of data for test/development servers. This would be controlled by what group a server was a member of.

    30 votes
    How important is this to you?
  8. monitor specific services status and specific event logs entrys

    this would really be useful to monitor specific windows services status and related event log entry's (even filtering them would be nice)

    specially since the is no other way to monitor microsoft dynamics nav (navision)
    sql part is helpful but when the problem are on the nav service tiers or schedulers theres no way to check than manually.

    6 votes
    1 comment  ·  Admin →
    How important is this to you?
  9. Allow users access to view specific reports

    Currently I create a few reports for different business areas and e-mail them daily. It would be really useful if they could follow the link on the page and view their reports only without having access to the site in general. They could then use the report filters.
    Another idea would be to be able to create a reports page with a static link where I could put several different reports, users would have access to this page only and be able to view any reports created in real time.

    6 votes
    How important is this to you?
  10. View queries against specific database in real time

    View all running queries against a specific database with the details of the query and its duration.

    This will help in monitoring a specific query in any particular time

    17 votes
    How important is this to you?
  11. Make alert configuration levels more discoverable

    CONTEXT: In SQL Monitor, you can configure alert behaviour down to the object level (such as the Database or the Job level). This is useful e.g. when we have specific databases with different backup policies to our global configuration, since we can specifiy "special rules" for individual databases.

    PROBLEM: It is counterintuitive how to do so, and many people don't spot the left-hand drilldown navigation - this makes you think that you can only configure on the global and the server level! Also, when we have created an override, it's easy to forget so causes surprise when we change the…

    178 votes
    How important is this to you?
  12. Get the proc name from a deadlock alert

    The Alert gives objectId and databaseid but your average 'accidental DBA' doesn't know the command

    select OBJECTNAME ( objectid [, database_id ] )

    Perhaps somehow suggesting the command as context sensitive help?

    30 votes
    How important is this to you?
  13. Install SQL Monitor without needing to provision a (large) SQL Server database

    CONTEXT: One challenge with installing SQL Monitor is that we need to provide a connection to a SQL Server database.

    PROBLEM: This can be costly or complicated. It would be better if SQL Monitor had an alternative backend.

    EXAMPLE SOLUTIONS:
    • Offer a hosted data store
    • Automatically deploy a free backend alternative such as mongoDB or PostgreSQL
    • Reduce data collection so that SQL Express can be used for small deployments
    • Provide greater granularity over data retention policies

    What do you think about these solutions? Got another idea? Let us know in the comments!

    153 votes
    How important is this to you?
    Adam responded

    We’ve made some improvements in this area but will leave it open so you can continue to give us your suggestions

  14. Monitor Azure SQL DWH

    It'd be great to be able to monitor performance of queries on Azure SQL DWH, as there are a number of DMV's available to track usage. Also, the ability to see on the Dashboard what DWU level the Azure DWH instance is running on would raise value and awareness of the cost of it, at that point.

    13 votes
    How important is this to you?
  15. Desktop notifications

    Desktop notifications would have (at least) 2 advantages:

    1) It would give much quicker access to the critical alert information than a regular alert email, since you could layout/format the notification with perfect flexibility (as opposed to default email client notifications which devote most of the real estate to the "from" address, and subject and body in plain text)

    2) With a couple buttons, the notification could give immediate access to actions such as "clear" or "mark as read"

    13 votes
    1 comment  ·  Admin →
    How important is this to you?
  16. Monitor SSAS databases

    I would like to be able to monitor SSAS cubes and data structures in the same fashion as SQL databases.

    53 votes
    How important is this to you?
  17. Resize the columns

    Be able to dynamically resize, refit columns so details could be seen.

    4 votes
    1 comment  ·  Admin →
    How important is this to you?
  18. See disk percentage free/used to Machine overview page

    It would be useful to see disk percentage free/used on the machine overview page next to the used / allocated column. This would give us a quick idea of how full the machine's disk is percentage-wise without having to do the math elsewhere.

    17 votes
    How important is this to you?
  19. Reduce false positives due to log shipping / Mirroring

    On secondary server for log shipping/mirroring false positives can be generated for overdue backups/databases unavailable. If these technologies are used for DR purposes then having the checks ignored is unsafe. It is trivial to filter these out with the below code and I'm sure there is something similar in place for Availability Group databases already.

    SELECT *
    FROM sys.databases
    WHERE name NOT IN (SELECT secondarydatabase FROM msdb.dbo.logshippingsecondarydatabases UNION SELECT dbname(databaseid) FROM msdb.sys.databasemirroring WHERE mirroringrole_desc = 'MIRROR')

    18 votes
    How important is this to you?
  20. Use extended events instead of trace when trace initialized due to alert

    I have seen a related idea https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/5717202-use-extended-events-for-deadlock-tracing-instead

    However, I'm expanding this. If the SQL version is high enough the trace of current activity should be using extended events instead of a trace, this would reduce the total impact to the server performance while also expanding the available information.

    98 votes
    How important is this to you?
    Daniel Rothig responded

    Thanks for the suggestion – we’ll monitor how popular it gets

  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base