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

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Display parameter list in the query plan form

    It would be great to be able to see the parameter list from the query plan in the "Query Plan" form without having to download the plan and traversing the XML file.

    It would save time troubleshooting problematic queries.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Create custom user roles

    We would like to create custom roles to grant granluar access to specific functions/features in RedGate SQL monitoring console. Currently, permissions can be granted on monitored objects not on functions except using existing Reporting and Viewer only roles. There is no option to grant Estate access to selected team members or groups.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. I would like alert sounds.

    Every product I have used in the past allowed for an Alert sound that you could turn off and on. I get that this is annoying to some people but for certain alerts I like to have a sound on them because I am not LOOKING at RedGate or my email, but I always have RedGate open. So setting any High alerts to a certain sound let everybody in the office know that there was an issue.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. Resizing Reports

    It would be quite good if you could edit the size of the report and stretch to make it easier to read. Currently (may be an option to) the data over a 7 days period for example is condensed.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. DatabaseName custom message parameter addition for Custom Webhook messages

    I would like to share with the developers the alerts for the different databases we have in the same server instance. I noticed for custom webhook messages. It looks like the option was there (like monitoredEntity.azureSqlDatabaseName).

    One of the SQL instances we have is a shared instance with multiple databases so the owner of the database can know exactly what database is failing

    Right now I have the following custom message

    {

    "text": "{{alert-severity}}: An alert of type "{{alert-name}}" has been "{{alert-status}}" for {{alert-target-name}}.\r\nVisit {{alert-url}} for details."

    }

    Where I cannot specify which database is that alert for. I consider…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Connect to Azure database via express route

    Currently I'm only able to connect to Azure SQL Server (PaaS) via internet and URL servername.database.windows.net.

    We have a direct connection to our Azure environment via Express Route. Therefore I want to use this also for the monitoring, but per default SQL Monitor uses external URL.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Get notification for when a SQL Agent job is in a retry state

    Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustrating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Get notification for when a SQL Agent job is in a retry state

    Hi, it would be really useful if SQL Monitor could identify when any currently executing job steps are in a retry state. We have many such jobs and the time lost whilst they are in such a state is frustarating as if we had notification we could take action. I appreciate I can roll my solution but would be nice if SQL Monitor could do it :)

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add a description for users in the manage users for active directory

    In some environments, the user login doesn't necessarily match the true user's name. This would help navigate what the user is assigned to that specific account.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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…

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Job Duration Unusual: ability to set different thresholds for different jobs

    Some jobs that take a few minutes, others routinely take a longer time to run, and so it would be useful to set different thresholds for different jobs.

    The current set up allows for excluding jobs from the alert, but offers no way of still monitoring those jobs.

    I only want to exclude the jobs from monitoring, only if its possible to add in another alert just for them.

    The documentation seems to hint that you can configure different alerts for different jobs, but all I've found is the high medium low thresholds, and this isn't the same.

    This combined…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Export a Databases report to Excel including Name, Availability, Transactions/sec and Database size for any time period

    In SQL Monitor I want to export a Databases report to Excel including Name, Availability, Transactions/sec and Database size for any time period. You can see this data and screenshot it, but it would be much more professional, useable and positive for management if I could deliver it in Excel instead of combining screenshots.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Suppress Free Space monitor (Azure Hyperscale DB)

    When using Azure Hyperscale DB - the DB auto grows - therefore the Free Space monitor needs to be silenced/ignored forever (except if you about to hit the max of 100TB!)

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Alert for full filegroup

    if a database is a fixed size (max size set), or if the db is initially set to be the full size of a disk, there is no alert to let us know that the database is full.

    for instance - if T: drive contains tempdb (and only tempdb) and we've sized it to take the whole drive. we've done funky sizing and growth settings so we can get an alert when the db grows, but once its grown and the temp objects are cleared, we're unlikely to get another disk warning, because the DB will already be taking 100%…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. Filter for Database with no Tlog backup

    On the Estate->Backup page, it would be great to have an additional drop-down option for 'DBs without Tlog"

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. Configure job duration unusual alerts to ignore negative variances

    Typically (although there are exceptions) I'm not concerned if a job has a high negative variance compared to baseline. One other way to satisfy this would be another suggestion already in here, allowing for more configurable options such as a floor/ceiling variance .

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 25 26
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base