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.


In Redgate Monitor, I want to...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • or

716 results found

  1. Testing the Availability Group listener(s)

    If an Availability Group listener is not working for any reason (like no DNS resolution), but the ressource is still up in the cluster, SQL Monitor will not raise any alert.

    Could you add a specific test for SQL monitor to test the connection using the availability group listener(s) and raise an alert if not successful?

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

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

    25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close
    Daniel Rothig responded

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

  3. Add User Settings feature

    Add a User Settings feature that will hold all user preferences, as different DBAs / users have different ways in using SQL Monitor. For example - (1) ability to display on the Overviews page only desired health levels (Critical, Warning, etc), or named group, or base monitor, or any combination, rather than load all servers from all groups from all base monitors. I really don't want to know that I have 265 healthy out of 275 servers - this will speed up loading of the Overviews page. (2) any other user preference.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  4. Add the ability to create new alerts

    Instead of limiting the available alerts to a pre-defined list, allow users to create new alerts and threshold metrics based on customized queries. In my opinion, this is about the only glaring omission in the current version of sql Monitor.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    6 comments  ·  Admin →

  5. 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)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  6. 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)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Admin →
    completed  ·  Adam responded

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

    Thanks again for the suggestion and votes.

  7. know who ran SQL Compare and what changed

    within SQL Monitor when it flags that SQL Compare ran, it would be good to be able to see who ran the job and what was changed. Currently the job is flagged in SQL Monitor but there seems to be no further details other than what database it ran on.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  8. Trend Analysis and Forecasting for Azure SQL Database capacity

    A previous feature suggestion, https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122308-forecast-and-plan-disk-database-capacity, was completed in 2018. However, it does not include storage for Azure SQL Databases or Elastic Pools. While we can alert on this, we get no trend analysis or forecasting.

    Selecting All Disks and All Groups on the Estate | Disk usage page gets us "No disks match your filter criteria."

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  9. be able to extract all alerts at once rather than extracting for individual alerts via API

    Redgate Monitor API currently allows users to extract alert details for individual alert types. We need an API endpoint that can extract alert details for all alert types instead of calling the API multiple times.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  10. Don't check Agent status for Express Edition

    Whenever I add a server to the monitoring that is Express Edition, I get alerted that the SQL Agent service is not running.
    Well d'uh. It's Express Edition. The Agent service cannot run on it.

    Instead of always giving me this alert and then having me go in and disable it for yet another server, why not change the logic to not raise this alert at all when the edition is detected as Express?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  11. date format

    I'd like to have an ability to set date format according to the country where the monitored SQL server is in, e.g. USA where date format is MM/dd/yyyy vs UK as dd/MM/yyyy. Also, why not to read and set date format off of the monitored server? Please make it configurable and country compliant so to speak..

    Thanks,
    Yuriy

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  12. Filter Longest Running Queries Tile by Database

    The Longest Running Queries Tile on the Reports screen would be more useful if we could target only one database.

    20 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  13. Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them.

    Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them,
    the infomation is avalible in SQLServer version 2005 onward in the following DMV
    sys.dmdbmissingindexdetails
    sys.dmdbmissingindexgroupstats

    sys.dm    dbmissingindexgroups
    sys.dm    dbmissingindex_columns

    So I still have to go off and check.
    Overtime as database grow in size and data distribution of the tables changes therefore indexing requirements change, so unless you monitor these DMV's you may not notice that an index may be…

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    declined  ·  Daniel Rothig responded

    The missing indexes DMVs are not an exact science, so we’ve decided against presenting sometimes-helpful, sometimes-disasterous tuning advice in SQL Monitor.

    However I’m confident that SQL Server itself will continue to evolve as a tuning platform, leaving SQL Monitor free to look at the bigger picture.

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

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  15. Capture cursor SQL for long running queries

    It would be great if SQL Monitor would capture the SQL statement being executed for long-running cursors. Currently it shows "FETCH CURSORNAME001"

    Cursor SQL can be found with this query when the cursor is still open:
    SELECT c.sessionid,
    c.cursor    id,
    c.properties,
    c.creationtime,
    c.is    open,
    c.fetchstatus,
    c.dormant    duration,
    s.logintime,
    t.text
    FROM sys.dm    execcursors (0) c
    JOIN sys.dm    execsessions s
    ON c.session    id = s.sessionid
    CROSS APPLY sys.dm    execsqltext(c.sql_handle) t

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  16. Have a standard metric for Data space used

    There is currently an out of the box metric or Log Space Used, but there isn't an equivalent Data Space Used.

    I get that it's a bit trickier if you have multiple data files, (even just adding them up as one metric). We have databases that we want to pro-actively allocate space for but it's hard to do without a metric to tell us when it's getting full.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  17. Environment specific Reports

    As we have option to create different reports on SQL Monitor, We would like to have the option to create the reports as per environment (Dev,UAT,Prod) for Disk Space,Server Downtime etc. It will be more feasible if we can get a filter to create reports for the specific environment.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  18. Configure Alert-Ended messages at alert type level

    in the global settings I can configure, that I want to receive deescalation mails when an alert ended (e.g. CPU went back to normal, Server available again ...).

    For many alerts this makes sense, but for other alerts not so much or not for everybody (e.g. deadlock alerts, the custom failed-logins alert, job-failed alerts...).

    So it would be nice, if I could configure this (as most other options) at least at alert type level or better down on group / server / database etc.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 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)
    Close
    Close

  19. suppress emails during maintenance window

    Allow the ability to suppress all alert emails during a maintenance window. Right now we have ~65 SQL servers and during windows when the OS team is patching and rebooting the servers we can receive 100's of emails as the servers go up and down. It would be great if we could set a schedule or at the very least a single use window when emails don't get sent.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    completed  ·  Neil Turner responded

    Thanks for this suggestion. SQL Monitor 10 now allows teams to suppress alerts, or just their notifications, over certain periods using alert suppression windows. Please see What’s New in SQL Monitor 10 for more details (https://www.red-gate.com/hub/product-learning/sql-monitor/whats-new-in-sql-monitor-10).

    We hope this meets requirements and will mark it as completed. Please raise further suggestions for any improvements you would like to see.

    Thanks,

    SQL Monitor product team

  20. Few suggestions:

    • Display the Job Name (character string) instead of hexadecimal value (SQLAgent - TSQL JobStep (Job 0x442BC6B49DA6FC41A98697F8C2F68956 : Step 1)
    • In alerts configuration: Be able to exclude Long-Running query alerts (or any type of alert) for a specific time frame. For example: between 11:00PM and 5:00AM
    • When selecting an alert details view, create a link to be able to come back to previous alerts summary screen instead of selecting Overviews link and then again narrowing down to alerts summary by server let’s say…

    80 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    declined  ·  Daniel Rothig responded

    Hi, because these are multiple suggestions and it’s not clear who has voted on what, I am going to have to close this suggestion.

    If you are interested in the Job Name request, please open a new suggestion for this

    If you are interested in the Time frame suggestion, please vote on: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122008-suppress-performance-related-alerts-during-mainten

    If you are interested in returning to the Alert Inbox from the details view, this has been implemented in SQL Monitor 3.3

1 2 … 17 19 21 … 35 36
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)