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.


683 results found

  1. Activate the alert suppression on a database level

    In our production environments we'd like to be able to suppress all alerting on a database level.
    For instance, if a database is to be retired, it will go into an automatic offline state for 2 weeks before it's actually deleted. During this period SQL Monitor keeps returning with a High Alert level warning that the database is not available.
    Yes it's possible to manually disable this alert just for this database. However if we want automatic ticketing to kick in on this alert type we'd need to able to create a maintenance window before hand in order to prevent…

    7 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)
  2. Overviews Alert Severity Colours

    When I go to the overviews page the servers have different alert levels represented by a colour and a symbol. I would like the choice of colours to be easier to identify for colour blind people, so the healthy, low and medium have colours that are almost identical to colour blind people as the contrast is so similar: https://personal.utdallas.edu/~melacy/pages/2D_Design/Itten_ColorContrasts/ColorWheel02.png

    2 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)
  3. Customize alerts at the host level in a windows cluster

    Currently you cant customize host level alerts at the host level only at the windows cluster level.

    A few scenarios where this is needed :-

    Always-on cluster where one node is for the application and you have a read-only secondary for reporting. I need to be alerted for the application node for high CPU, but the report server is usually often hits 100% CPU during business hours.

    Multi node regular failover cluster with different application owners. 3 nodes, app1 lives on node1, app2 lives on node2, node 3 is a passive node for both. Alerts for app1 need to go…

    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)
  4. Monitor SQL Server Analysis Services

    It would be really nice if we could monitor SSAS Instances with the SQL Monitor.

    7 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)
  5. Integrate query store with monitor to find regressed queries

    Query store already tracks regressed queries. Integrating this into the monitor and having the ability to alert on this would be extremely useful in having early notifications on when a query goes bad before application or system issues come up

    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)
  6. Shorten the focus window from 15mins to 1min

    I want to be able to apply a shorter timescale to the focus window, 15mins is far too long on a very busy system.

    I would like to be able to put a start / end date/time instead of selecting a time and then x hours before that

    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)
  7. Add Database Filtered in Top 10 Queries\Wait Section

    Can you Add Database Filtered in Top 10 Queries\ Wait Section.
    We have more than 500 databases in instance . If you add Databases filtered than we will very helpful.

    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)
  8. Control the delay before getting "Error on Base Monitor"

    We have perhaps a unique use case where one of our Base Monitors is at a remote site with a very high latency (700+ ms). Monitoring works surprisingly well since one of the later updates but unfortunately we are getting regular “Error on Base Monitor” emails (10+ per day) even though the connection itself is stable (just very slow).
    We would like to be able to control the delay before that error is raised, I’m guessing that slightly increasing this "timeout" would fix all our issues.

    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  ·  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. Trace schedule

    Could the new "Trace" feature have a schedule as well as an on/off? If not this then how about a third option "Trace until date/time"?

    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)
  10. Easily identify which base monitor is hosting a monitored SQL Server host

    In a multi-base monitor configuration it is a bit cumbersome to identify which base monitor is hosting a given entry on the overview page. Yes, one can search all the SQL Server host machines on each base host, but that takes time. It would be better to have an entry in overviews that identifies where it is hosted.

    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)
  11. 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  ·  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. I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS

    I use SQL Monitor every day and use the failure reports for SQL Agent jobs, it is most useful. However, when there is an issue with an SSIS package that is automated via SQL Agent I have to leave SQL Monitor and go to SSMS. It would be really handy if SQL Monitor could read the SSIS errors. Is this something that is in the road map or could be put in please? Thanks.

    13 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)
  13. Configure Different Emails for alert levels

    Allow for customization of emails for alerts at each alert level, so that I can send to different emails for each alert level.

    So that I can send High alerts to one email address, medium alerts to another email address, etc…

    57 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)
  14. Add the ability to optionally fire a data gathering query if an alert fires

    For example, https://sqlmonitormetrics.red-gate.com/suspiciouserrors/ (Detect Suspicious Errors Typical of a SQL Injection Attack)...

    If suspicious activity crosses a threshold, it throws an alert. Great. Now what? I have an alert but no data to investigate without opening SSMS (or tool of choice) and running a query like this (I’m sure there are better ways but this works for an example)

    SELECT CAST(targetdata asxml) AS targetdata
    INTO #SuspiciousErrors
    FROM sys.dm
    xesessiontargets xet
    JOIN sys.dmxesessions xes ON xes.address=xet.eventsessionaddress
    WHERE xes.name='MonitorSuspiciousErrors'
    AND xet.targetname ='ringbuffer';

    SELECT
    dateadd(mi,datediff(mi,getutcdate(),getdate()),xed.eventdata.value('(@timestamp)[1]','datetime2'))AS EventTime
    , xed.event
    data.value('(data[@name="errornumber"]/value)[1]','int')AS ErrorNum
    , xed.event

    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  ·  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. sql estate email out option

    It would be great if you could set up an email routine to email out reports from the Estate tab. E.g. the backups tab would be useful to email out an export of the screen.

    2 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)
  16. Different email addresses for different thresholds

    Although you can specify different thresholds for High, Medium and Low alerts, they all end up at the same email address or slack channel. It would be useful to be able to change this so highs went to one address, mediums to another etc.

    31 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)
  17. Prevent Active Directory lockout from a single failed attempt to log into the dashboard

    If the user mistypes their password when trying to log into the SQL Monitor dashboard, their Windows account gets locked out in Active Directory. This happens on the first failed attempt, so presumably there's an automatic retry happening.

    (This ticket is similar to https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/16845169-keep-from-locking-account-when-registering-server, but that one is for the server monitor login and this is for the dashboard user's personal login)

    7 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)
  18. 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  ·  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. Exclude System Databases (and potentially other user databases) from backup alerts

    We would like the ability to exclude system database from the backup alerts, as we do not back them up. We have a system in place to script out security and sql agent jobs/schedules for each of our systems nightly. We also have been leveraging the dbatools PowerShell stack as a way to automate server migrations and other automation activities. Also, our tier one systems are in availability groups. Lastly, we do not backup everything in our lower level environments, as we perform nightly database refreshes for the majority of our systems. However, we do have some testing databases that…

    15 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)
  20. 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  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
1 2 8 10 12 34 35
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base