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. With the AG Groups it would be good to have soft alerting on configurations

    With the AG it is possible to have different configuration on the server replicas. We mostly get caught out with Logins. but have had issues with XMLBlob size, linked servers and Server Master Keys.

    It would be good for monitor to alert (or be able to alert) if a Login does not exist on both (all) replicas. we have times when a quick addition through SSMS does not put the same login on all side. when fail over occurs we then have broken processing. It would be good for sids to be checked as well as this is another issue…

    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  ·  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. We would like to send slack messages to different channels depending on the server.

    We have multiple teams who are ultimately interested in what is wrong with their platform, The posting to a single slack channel is good, however giving an option to send only messages from certain servers to specific channels would improve our customer engagement. currently the main channel is ignored by the all teams except the dba's as the chaff from other servers can cause disinterest, or interest when no reason for a team to investigate.

    9 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)
  3. Azure AD modern authentication for SQL Monitor

    Be able to login into Redgate SQL Monitor using AAD with multi-factor authentication

    13 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)
  4. PaaS dbs on an instance appear seperately

    Hi Redgate Support,
    While adding PaaS SQL servers, each database appears individually. Will this change in near future where they appear together with other database on the instance like they do on-prem and on IaaS.

    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  ·  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. Word Wrap Alert Comments

    Super minor detail, but it would be a more pleasant experience if I didn't have to use a scroll bar to read comments on Alerts. If it were word wrapped in some manner it would make the user experience better for me.

    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  ·  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. Select custom date range in Estate - SQL Agent Jobs

    Would like to be able to view SQL Agent Jobs between dates. Currently you can pick from Day - Week - Month but it would be really good to have "Custom" also which allows you to select start and end date.

    44 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)
  7. Ability to not monitor/show certain queries in the TOP 50 list.

    The top 50 query view in SQL monitor is showing the query that is running on the service broker queue with explicit waitfor statement. In our server these waitfor is 5 min and we have 100 threads that runs for 5 minute and wait for the messages in the queue.
    The query monitor shows these query as the top slow performing queries, but in reality these are not slow queries, they are just waiting for messages in the queue. We need a way to not show up the queries in top 50 list, so the queries that are actually slow…

    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  ·  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. I'd like it to be more obvious that an active alert is no longer a current and unresolved issue

    Whenever an issue is flagged, for example in the night, it changed the server to red. Once you click on that, the state is "active" (more un acknowledged I would say if not current). For me it is not clear if that issue is still ongoing or that it had been an issue and is now resolved.
    Can it be made clear what the end time is if the alert is no longer active? (right now only start time is 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  ·  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. In SQL Monitor, I want to use a variable description in a custom alert.

    Some custom metrics could be about things like a specific disk, job or DB-object. At this moment it's not possible to specify those in a generic Alert.
    If besides the metric value a descriptive value was allowed, it would be possible to parse the descriptive value into the Alert.

    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  ·  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. Automatic validation of regex for Long-running query configuration

    When applying regex filters for long-running queries, a malformed expressions causes the page to just drop the error and not take the save action.
    My suggestion is to just implement a basic regex validation and prompt/indication on error.

    2 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)
  11. I want to be able to apply tags to SQL servers in SQL Monitor to better sort

    I want to be able to create more groups that a server is a member of. For example, I want to see all Production servers, or all servers associated with a specific team or department. I can group by only 1 item now. But, if I could tag servers, that would allow me to be more granular in my reporting.

    We do the same thing in VMware now. We can still use the same grouping structure that exists today, just create the ability to provide multiple tags to each server/instance.

    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  ·  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)
  12. Disable specific alert for some time

    Make it possible to ignore a specific alert for a specific server for x amount of time. Sometimes there is something going on for say half a day and you do not want to miss out on other errors but just that specific one.

    2 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)
  13. FCI alerts should refer to the DB instance and not to the active node

    For various alerts that are actually assigned to nodes of a Windows FailOver cluster (no AlwaysOn), the alert display shows the active nodes as the source. For example, "Disk average read time" Node1 -> E: instead of the cluster role SQL instance -> E:.

    I can more quickly deduce from the name of the DB instance which DBs or which applications could be affected. The names of the nodes are numbered and meaningless.

    1 vote
    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)
  14. be able to switch support for cloud-features and off based on company needs

    Some companies still operate on-premises only, others operate only for Amazon RDS xor Azure. Having all these cloud-database features enabled clutters the user interface and I'd rather like to enable/disable such support through configuration options like
    [ ] enable Amazon RDS
    [ ] enable Azure SQL
    [ ] enable Azure Instance
    ...
    [ ] enable Oracle/xxx/yyy features

    5 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)
  15. Monitor Disk Overallocation

    Recently we ran into disk space issues on a server. Looking into that, it was discovered that a 10TB database had 3TB in "Unused" space. That is the space was allocated to a table, but the table needed to be reorganized to recover the space. sp_spaceused shows this space, and a disk report of top tables clearly showed the Unused space. This was not something that Redgate noticed. Going back over our estate, we discovered there were more such databases where we could recover space. This could also be noted at an individual file level. Reorganizing that one database has…

    2 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)
  16. Email queuing

    Basically, I would like email to queue up in SQL Monitor. In the event an email fails to send (account locked out, mail server down, etc), having the email just fail to send is not the desired result. When problems are resolved, the email should send.
    For example, lets say IT is doing scheduled maintenance on the email server and during that window one of the SQL instances shuts itself down due to an error (for arguments sake, lets say out of disk). SQL Monitor will see it go offline and try to send out the alert but fail because…

    5 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)
  17. see an administrative web-based log viewer

    Having the ability to review logs in a web-based interface is useful for administrators of a tool so we can diagnose and remedy some problems without needing to reach out to support. The downside is the log needs to be filterable or multiple log files need to exist.
    An example of a log that would be useful would be an email log. In the event an email fails to send, I'd like to know why without needing to download the entire log in a zip, extract the zip locally, and browse through it when I am looking for a specific…

    2 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)
  18. A way to showcase all SQL Statements running for a specific time frame

    A way to showcase all SQL Statements running for a specific time frame. This is will be helpful to investigate any issue that occurred in the past.

    5 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. Suspend Monitoring of Individual Cluster Nodes

    Alert suppression windows can be applied to groups, clusters, instances, and machines - including individual cluster nodes. Howerer it seems it is only possible to suspend monitoring for instnaces or clusters not individual nodes,

    We recently had a hardware fault and it would have been helpful to suspned monitoring of a specific node whislt the engineer resolved the fault.

    3 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)
  20. Long-running query Alert - time based parameters

    I need to disable monitoring long running queries at night.
    My proposal is that you could add new parameter to alerts
    Time from - Time to which will exclude monitoring during this time.

    That will help to exclude ETL - ssis, and other long rununig queries which we set up at night.

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

Suggestions

Categories

Feedback and Knowledge Base