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. Ability to export backup history detail for providing audit information easily.

    possibilities I can think of that might help to add are each backup having it's own export button when the backup history graph is expanded out, including the backup history on the current excel sheet or possibly having a summary report for it in the Reports section

    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)
  2. Record queries terminated by the client

    We use an ADO client with a query timeout of 30s by default.

    These queries are not being captured by SQL Monitor. If they were, it might highlight the cause of why they are taking so long.

    For context, we have a query that regularly takes a couple of seconds to execute, but every hour or so exceeds the 30s timeout and we would really benefit from SQL Monitor to capture those to help diagnose why.

    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)
  3. Extend field width of Server Selector field on top of Dashboard to be the same width as the Drop Down

    Go to Dashboard; Overview tab; drill down to one of the servers. On top of this next form (Server Host Metrics form) is the Server Selector field with a Drop Down list box. When you select the down arrow key to open the List Box the width of the List box is about twice the width of the Server Selector field. Is it possible to make the width of the Selector field the same as the drop down or make it user defined/variable? Right now it's around 27 chars. We have long server aliases/names so if extended, it will help…

    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)
  4. 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)
  5. show sql related windows event log entries

    Rather than going through all Windows event log entries looking for SQL related events on every monitored server, it would be good to have them displayed on the server screen along with the SQL Error log entries.

    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)
  6. Have a way to exclude Deadlock alerts based on the T-SQL or Proc name

    I would like to exclude alerts for deadlocks based on a procedure name or other T-SQL, just like I can do for LRQ and other alerts. Please see http://productsupport.red-gate.com/hc/requests/170766

    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)
  7. Add a Description field in the Databases section

    Dashboard, drill down to the Databases Screen. In that section, there are currently 4 fields or columns - Name, Availability, Transactions/sec, Database size. Will it be possible to add another string field to store a high level description of the database; this will be really useful for our users. Can the new field comes after the name, be 200-300 characters in length and can be a pop-up if a mouse pointer hovers over it. Many thanks.

    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)
  8. Have ability to configure alerts to be active for various periods.

    I have multiple alerts (including custom alerts) on serves. I would like to configure alerts to have different thresholds for diffident periods (weekday/ weekend) OR (mornings / evenings ) OR other periods.

    Like log sizes on weekends (mostly due to index maintenance) can be much higher than weekdays.

    Current "alert suppression windows " applies to a host and to all alerts on it and not to specific list of alerts.

    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)
  9. Have filter on failed SQL Server logins alert

    I would like to edit the Failed SQL Server logins alert to exclude failed logins from a value like a host/IP address. We have our security guys trying to break in our SQL servers daily and it trips the failed SQL Server logins alert all the time and over alerts us.

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

    see the full SQL in deadlock Area. Today with long querries you can see only part of it

    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)
  11. 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)
  12. 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)
  13. Suppress Specific Alerts

    There are some alerts that get triggered at odd hours and I would like to be able to suppress just those specific alerts for a certain time frame. I'm afraid to suppress ALL alerts because something could get missed.

    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. track blocking processes date/time by start time, not login time

    in blocking tree, it shows old date/times for queries that are running. We found that it is using the login time of the spids (which could be held and sleeping for extended amount of time) instead of the start time of the executing process of that spid.
    instead of using the login time, I recommend it uses the start time of the last execution of the query found in sys.dmexecrequest

    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)
  15. Availability Group alert details

    It would be great to see the server name in the mail body which is affected by the alert. Currently it is only in the subject. EG: Raised on detail i the mail body contains the primary replica, the affected unreachable replica is only in the subject.

    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)
  16. 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)
  17. 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)
  18. Control Alerts For Managed Instances Separately From On Prem.

    Some guidance for Azure SQL Managed Instances is different from on prem SQL Instances. For instance, there is information out there not to just do routine index maintenance and instead do statistics and only rebuild indexes when there is an obvious problem. Having a way to keep our current alerts for on prem and turn this off for Azure would be helpful.

    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)

    Hi Tom,

    Thanks for your suggestion. Can you provide a bit more context for your suggestion? What goal are you trying to accomplish?

    Would the current ability to control alert settings by group not be sufficient for this?

    Thanks,

    Neil
    (SQL Monitor product designer)

  19. Be able to see and dissect alerts for deadlocks on the AWS RDS platform.

    Currently, SQL Monitor does not raise deadlock alerts for AWS RDS database instances. I'd like this functionality to be added, as it's a major feature and selling point for the product.

    The current workaround we're using is a combination of AWS performance insights and a SQL script. A "single pane of glass" would be much more efficient.

    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)
  20. Improve filters available for alerts

    A recent incident I have been working on revealed to me that filters work based on last update which makes it hard to find alerts that you know would have started around a specific time. The ability to filter on start/end times as well as show this information in view returned.

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

Suggestions

Categories

Feedback and Knowledge Base