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.


198 results found

  1. to see 24-hour clock affecting times on graphs

    I see the setting and it is set and in most places it is used but not in the time axis on graphs in analysis.

    6 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 have just released version 7.1.3, available from Check for Updates, which fixes this issue.

    Thanks for the suggestion, and for your patience,

    Adam

  2. display unlicensed servers in different color

    We started with RedGate Monitoring and added all our SQL Servers. As a result we consumed too much licenses. Although there's a warning on the top of the screen for this, the unlicensed servers are reporting 'healthy' which is a little tricky (especially for non-dba it'ers) because you don't know the state.

    I like to see the unlicensed servers in a different color ( for example gray) to see a better reliable overview

    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  ·  Neil Turner responded

    Unlicensed servers are now shown as grey on the global dashboard.

  3. Allow the pinning of availability groups to the Global Dashboard

    I'd like to see the status of my AGs on the Global Dashboard without having to find them inside the server. Would also nice to see stats on latency on this widget.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  4. Exclude databases with state = 1 (RESTORING) in page verification alert

    During a restore the page verification alert gets triggered, even when the database has CHECKSUM page verification. Please exclude database with state = 1 (RESTORING) in this alert! Thanks!

    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  ·  Adam responded

    Thanks for this suggestion.

    Version 9.0.4 has now been released and the Page Verification Alert will no longer alert when a database is being restored.

    We hope this works as you expected and will mark this as complete, but please do let us know if you have any further comments.

    Kind regards,
    SQL Monitor Development Team

  5. Dynamic Report names

    It should be possible to have dynamic fields in the report name similar to the way Backup Pro implements backup names. So when the report is emailed the attachment could be easily saved without having to rename it.
    For example "MyReportsBaseName<YYYYMMDD><HH:MM>"

    6 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)
  6. See last backup of each type in Overview page

    Currently the backup section in a database on the overview page shows the backups that happened in the selected range, and it only shows the last backup of each type that happens. We have a database that does full backups once a week and then differentials.

    It would be helpful at a glance to see the status of the last backup of each type regardless of if it happened in the time window or not. Maybe hide the last differential if it happened before the last full.

    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  ·  Adam responded

    We have redesigned the Backups information to more clearly show the selected range it refers to, and also show when the last backups occurred prior to that. This can be seen in the latest version (8.0.25)

    We hope this improvement completes the suggestion and will mark it as completed. Do let us know if you have any further feedback

  7. "Installed Versions" tab needs to be aware of GDR updates

    Only Service Packs and Cumulative Updates are currently included in the version list maintained by Redgate, which drives the "Installed Versions" tab. GDR updates are not included.

    In my estate, this has resulted in SQL Server 2012 SP4 installations showing as being fully up to date, when there is a GDR update from January available, to address Meltdown/Spectre.

    Microsoft's official line on GDR updates for SQL Server is:

    "A GDR addresses an issue that has a broad customer impact, that has security implications, or that has both. A GDR is determined and issued by Microsoft as appropriate and when appropriate.…

    6 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)
  8. Add alias with powershell module

    We install our sql server automatically via powershell, so we also add them there to the monitoring. We would like to safe us work, by giving the server a custom alias while adding to the monitoring as it can be done through the website.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  9. 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.

  10. 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

  11. Missing database name in blocking session alert

    When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.

    Blocking Session ID: 93
    Number of blocked descendants: 1
    Total blocking duration for all descendants: 00:03:02
    Blocking SQL fragment: CREATE PROCEDURE [dbo]...

    In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).

    So please add the database name to the blocking session part too.

    5 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

    Thanks for the suggestion. Version 7.1.3 has now been released and improvements include adding the database name to the Blocking process alert.

    Kind regards,
    SQL Monitor Development Team

  12. 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…

    5 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

    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

  13. 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.

  14. 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.

  15. Regarding Custom Metrics - allow us to either have the "Description" inserted into the email or give us another text field for annotating.

    We have solution documents in a help desk application. I would like to have my error message emailed with a suggestion that the recepient reference the solution document for steps in resolving the problem.

    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  ·  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. For custom alert, emails now include description.

    Thanks,
    SQL Monitor Development Team

  16. Configure disk space alerts at individual disk level

    I'm able to get away with some disks running closer to capacity than others. (not all drives hold SQL!) it would be nice to be able configure alerts to reflect this and have the email alert display which disk is causing the problem.

    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)
  17. increase or decrease the fill factor

    Dear team.

    I see some explanation on the sql Monitor live Demo tool which seems incorrect:

    Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting

    increase should be decrease: the higher the fill factor the less…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  18. Recognize Low Alerts visually in overview

    Low Alerts show as blue dots on the Latest Alerts panel, but in the overview they show Green like Healthy.
    Especially when showing Small Tiles (we monitor 60+ instances) they do not stand out from Healty ones (see the attached examples).

    For that reason I dont use many Low Alerts.
    It would be more consistent to use blue in the overviews also.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  19. If a job fails the alert should not be cleared until the job has run successfully again

    If a job fails the alert should not be cleared until the job has run successfully again. It doesn't make sense clearing the alert just because a job has been restarted. The alert should remain active until a completely successful run.

    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  ·  Neil Turner responded

    This has been changed and now works as described here. In SQL Monitor since 11.2.13 (released 26 Sep 2021).

  20. 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)
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base