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

721 results found

  1. create user permissions script

    provide the sql to run for users to use during install to assign permissions to the back end database use and the monitored db use

    obviously explain about the SysAdmin problem with your product

    https://forum.red-gate.com/discussion/80787/required-permissions-changed-after-upgrade
    https://forum.red-gate.com/discussion/80448/new-permissions-needed-for-monitoring
    https://documentation.red-gate.com/display/SM7/Permissions

    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. Check both full and differential backups for the overdue alert

    As it is, the backup overdue alert will not check if a differential backup has been run.

    Example: We have a database with simple recovery model that is set up to make a FULL backup every week, and a differential backup every day. If the alert level is set to "more than one day" then it will be triggered even though the diff backup has been run, indicating that it is not overdue.

    We could set (and do that) the alert level to check only for "more than 7 days", but then we will not be notified if a diff…

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

    Thank you for this suggestion, and apologies for not updating sooner.

    We believe this was solved when the Differential Backup Overdue alert was added in Version 8.0.7 (May 2018) . This alert is raised when entries for a differential or full backup in the [msdb].[dbo].[backupset] system table are older than the time you specify.

    We will mark this as completed but please do let us know if you have any further feedback.

    Thanks,
    The SQL Monitor Development Team

  3. increase or decrease the fill factor

    Dear team.

    I see some explanation on the sql Monitor live Demo tool which seems incorrect:

    Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting

    increase should be decrease: the higher the fill factor the less…

    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…)
    completed  ·  1 comment  ·  Admin →

  4. 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)
    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

  5. Limit the number of backup entries listed for Estate Backup details

    When viewing the backup details of a database in the Estate Backup view, the number of backups listed severly impact the usability. It seem to retrieve all backups done and stored in the SQL monitor DB or in msdb. As we have frequent log backups, this list is very long and heavy to retrieve and display.

    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

  6. Long-running query alert - add an option to exclude queries based on the USER running it

    This alert already has the options to exclude queries (via RegEx) based on the process name or SQL commands/objects used. I miss a similar option for excluding queries based on the user running the query.

    An example: let's say you have a job that runs SSIS job steps using a proxy->credential->dedicated domain user. The SSIS packages run loads of SQL queries, some taking a long time - but that might be expected and OK (let's say the job is a nightly ETL process for a DW). Without excluding queries based on that user (simple but effective!) you could get a…

    64 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…)
    9 comments  ·  Admin →

  7. Use error messages from SSIS catalogue

    When a job fails, which is run from SSIS Catalogue, then the error message is basically "look in SSIS Catalogue", which is not very useful. I suggest using the error message from the [SSISDB].[catalog].[event_messages] view instead for these cases.

    In our home made monitoring system we're checking the subsystem in sysjobsteps, then use the command from there to identify the dtsx package name and looking up the latest message from [SSISDB].[catalog].[event_messages] for that package for the error message.

    21 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. comment markdown

    CONTEXT: I use comments on alerts raised by SQL Monitor to document root cause of the triggered condition and resolution action.

    PROBLEM: Comments only support plain-text. When creating/reviewing comments, it's often useful to add links for more detailed descriptions of the cause of the alerts, and links to ticketing systems for resolution steps. Simplified bulleting/numbering and bold/italicized text would also be helpful for breaking up monotonous text.

    EXAMPLE SOLUTIONS: Add Markdown (http://daringfireball.net/projects/markdown/) support to addition/review of comments. A couple implementations for examples of usage:

    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

  9. add user editable notes in estate

    Add the ability to add some basic text notes for each instance that can be viewed in the estate view. Want to keep some basic notes such as purpose of instance, application server dependencies, etc. Currently use external document to keep track of these.

    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

  10. Share alerts via Email

    The ability to share alerts details via Email from the "Alert Details" page.

    Sometimes we don't want to share a direct link to the monitor.

    E.G
    Click "share" which will open a mailto: with the relevant alert details.

    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

  11. Overview screen show as a list

    Show the overview screen as a list of servers. If you have a large number of servers to be monitored, there is no way to see all of them at once (other than zooming out of the screen). It defeats the purpose of monitoring if you can't see everything.

    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. non sql servers should not need a license

    i think it would be very nice being able to have alerts for non sql servers without the need to allocate a license to those.

    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

  13. 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)
    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

  14. Within the estate section under backups, it would be great to be able to exclude the expectation of backups on databases that are SQL Clones

    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

  15. Allow Fractional Alert Thresholds.

    When you use the "Calculated rate of change" functionality on a custom metric, the results come back in fractional values and you should be able to alert on these values. In my case, I want to monitor number of orders for the last 10 minutes. There are always relatively few orders at night and many during the day, but if order flow drops off drastically in a short period of time, I want to know about it.

    Unfortunately, I can't just alert when the rate of change drops by 25% (-.25) because alerts can only happen on integer values. 100%…

    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
    Daniel Rothig responded

    A current workaround is to multiply the result by a factor, eg. 100 to make the result a percentage.

  16. Exclude a database, instance or the entire alert based on an actual alert

    It would be a nice feature to be able to click on an alert and get the option to exclude future alerts:
    1 - for this specific database
    2 - for this specific instance
    3 - for this specific alert

    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

  17. see sessions from sys.dm_exec_requests in top 10 queries

    I never see commands like BACKUP DATABASE or ALTER INDEX in top 10 queries and got the message from support that the information is taken from sys.dmexecquerystats
    As it is now it is hard to track down where heavy I/O comes from if it is for example index maintenance or backup.
    I think RedGate should record all commands from sys.dm    exec_requests and join in the execution plans where they exist and other stats if needed

    17 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…)
    4 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. be able to set top level notification settings through powershell module

    I want to be able to use Redgatesqm.ps1 to configure smtp server, default email list and other top level notification options.

    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

  19. Make comments apply to alert types, rather than individual incidents

    CONTEXT: We use comments to document the root cause of alerts we encounter

    PROBLEM: When alerts repeat, recovering the comments is a pain - they only apply to individual occurences, so don't get surfaced when they issues re-occur.

    EXAMPLE SOLUIONS:
    - Show historical comments in alerts
    - When creating alerts, allow us to choose whether this applies to the whole alert type

    ADDITIONAL CONSIDERATIONS:
    Comments should also show when configuring alerts

    32 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…)
    8 comments  ·  Admin →
    completed  ·  Carlos Eriksson responded

    As of v14.0.23 (September 4th)

    We have Redesigned of the 'Alert History' and 'Occurrences' tab in the alert details page. This combines them into one tab and allows for easier access to previous comments.

  20. Be able to schedule a maintenance window with the possibility to use an offset.

    Be able to schedule a maintenance window with the possibility to use an offset. Say every 3rd tuesday of the month + 12 days.

    5 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
1 2 … 26 28 30 … 36 37
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)