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.


  • or

733 results found

  1. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Daniel Rothig responded

    Hi Ben,

    Thanks for letting us know about this bug in our validation logic. It will be fixed in the upcoming version of SQL Monitor

  2. Some alerts show 2 different time zones on a single alert event

    On the alerts page I open a Database Unavailable alert that indicates a time of 10pm. The new page opens, and I see "Time raised = 10pm" but on the Details tab I see "Time = 6am"... it's showing UTC time instead of local time here. (Unless I've got something misconfigured!)

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  3. full table scans

    Highlight full table scans on big tables, so these can be investigated

    It could be these tables have grown, so initially they were ok, but now they aren't

    3 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. Be able to customize alerts by job

    I would like to be able to customize alerts by job. For instance, I have many jobs that run multiple times per hour. If it fails once or twice, I don't want to be alerted about it. However, if it fails 3+ times in a row, I want to be alerted.

    3 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. A report on the front page (Overviews) of the Sql service status

    A report on the front page (Overviews) of the Sql service status (Datbase Engine,Agnet,Reporting Service And etc )

    Using DMV "SYS.DMSERVERSERVICES"

    This Report includes Columns For Example : ServiceName,Startup-Type ,Status-Desc And Last Startup Time

    Tnx From Redgate Company Team

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Daniel Rothig responded

    Unhealthy service statuses raise alerts in SQL Monitor, which will be surfaced on the front page (future work on the front page will make this more parseable in SQL Monitor 5.2)

  6. Select multiple groups for "latest alerts" sidebar

    It would be great if we could select multiple groups in the latest alerts. For example, PostgreSQL Prod and PostgreSQL Dev/Test.

    Background: We work in several subteams, such as Postgres and MSSQL. I would like to see only the latest alerts for PostgreSQL Prod and Test, and not for the other groups.And I don't want to switch the groups from PG Prod to PG dev.

    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)
  7. 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)
  8. Alert based upon trend data

    We want to be able to alert when a value changes dramatically over a period of time. so if a system returns 110,105,112,40,38,52

    to eye ball that on a graph I can see there is a problem, however that may be at the peak time of the day and 38 might be a reasonable value for in the middle of the night, so having a threshold of a low value is not appropriate, the comparison mode of query for this situation would report a change of
    -5,+7,-72,-2,+14

    in here there is one large drop but then it is running stable,…

    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. Long Running Query Alert - Update Process Fragment Info for Agent Jobs with SSIS Packages

    One of the most common alerts that we get is the Long Running Query alert. However, when the query is due to a package executing from an agent job, there is little to no information about what is running long. The attached image is an excerpt from one of the alerts we got this morning. We can tell it is from an executing job, because of the SSISDB database specified. But beyond that, we are left trying to figure out which job/package was the culprit by digging through execution logs and schedules, then trying to match execution lengths with where…

    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)
  10. Option to display time zone with time display.

    Example:

    Long-running query Server1 2:05 AM (UTC-5)
    Blocking Server2 8:15PM (UTC+2)

    etc.

    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…)
  11. service now event creation

    ServiceNow integration current creates incidents directly in ServiceNow. Due to corporate standards we aren't allowed to directly create incidents. All monitoring integrations to ServiceNow have to create "events", which are then mappen within ServiceNow to incidents (where applicable).
    Please consider adding an option to create events instead of incidents.

    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. Don't bloat plan cache

    Fix this query so the nvarchar() parm is of a fixed size (or MAX). As is, each invocation is generating its own execution plan and bloating the plan cache.

    (@p0 bigint,@p1 bigint,@p2 nvarchar(560))INSERT INTO [data].[ClusterSqlServerTopQueriesInstances] ([Id], [CollectionDate], [QueryText]) VALUES (@p0, @p1, @p2)

    (@p0 bigint,@p1 bigint,@p2 nvarchar(159))INSERT INTO [data].
    [ClusterSqlServerTopQueriesInstances] ([Id], [CollectionDate], [QueryText]) VALUES (@p0, @p1, @p2)

    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  ·  Admin →
    completed  ·  Adam responded

    Completed in v6.0.3
    Thanks again for the suggestion, we appreciate your input.
    SQL Monitor Development Team

  13. Improve the resolution of the analysis graphs

    The analysis graphs don't plot enough points to be able to clearly pick out peaks and troughs in the data -- it all gets averaged out.

    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 →
    completed  ·  David Bick responded

    Absolutely. We’ve upped the resolution from 50 data points to 500 or so.

  14. Read Only users should not view Analysis page.

    When restricting "Read Only" users they can still see all servers when viewing the "Analysis" page. I think this should also exclude any servers not explicitly defined in the Managed Users page.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  Adam responded

    Thanks for this suggestion. This has been fixed in Version 9.0.6 (although I would suggest updating to the most recent version, v9.0.7 at time of writing) when we fixed the issue SRP-11791: AD user can see names of servers they don’t have access to fixed for Analysis and Backups.

    Hopefully this completes this suggestion.

    Thanks,
    SQL Monitor Development Team

  15. Check the plan cache ad-hoc or on a schedule to report issues

    implicit conversion,
    scans,
    lookups and the index that didn't have the columns include
    missing indexes
    Parameter sniffing
    etc...
    Report the issues based on impact number

    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. have the ability to customize browser tab labels

    Provide the ability to label browser tabs to indicate contents, such as "Host101 Disk Activity" or "Host102 Database Transactions" or "Host103 Disk Usage"

    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)
  17. 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  ·  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. Allow users to specify the time period in minutes for the top 10 expensive queries

    I would like to specify that exact minutes on the slider for Top Queries. Currently you can only do a 15-minute change. But I would like to be able to do that down to a minute range. Sometimes we make a change and I don't want to wait 15 minutes to filter out the previous queries.

    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)
  19. Be able to set an Alert to escalate when it has been active for a certain amount of time.

    I have a several different Jobs that fail periodically, once in a while is not a big problem but when they continue to fail over a period of time it does become a problem and I need to know. Likewise when I have an AG is slow to sync in the middle of the night when it is rebuilding all of the indexes of a 1.2TB database and syncing across to locations in 2 states I don't want to be paged, but if it is persistent through the day I do.

    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)
  20. I would like to set up an alert for disk space projection threshold

    Wanted to know if we can set up and alert when it reaches the threshold of less than a month of projection for disk - this is in the disk monitoring estate for Redgate .

    image.png
    Regards,
    Shaily.

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