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.

In SQL 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.

  1. FORCE "Estate" refresh re Actual Disk Space

    Just freed-up 55GB on tempdb drive. F5 on the Estate page, Disk Usage tab, and SQM still says 11GB. Clearly WRONG!

    Give us the ability for FORCE a disk usage re-calc.

    9 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 →
  2. Add "When File Grew" Drilldown to the new Estate page, Disk Usage

    The new Estate page is already proving useful, but today not as much as it could be...

    tempdb LOG suddenly grew to twice its normal size, and we have yet to trace why. It may have gone unnoticed but for SQM issuing a LOW DISK SPACE Alert!

    Please add a drilldown for DB files that show the times, and quantities, for growth. A sparkline chart would help, too, as a visual cue. for the last 30-days, perhaps.

    Thanks for continuously making SQM more useful.

    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 →
  3. Customize Alerts on the Overviews Page

    Allow for the customization of the Alerts in the Alerts section on the Overviews Page.
    These customized alerts would be independent of the settings for the Alerts tab. That way Alerts would just be customized for the Overviews Page.

    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 →
  4. Define limit of the specific job alert.

    problem : a job is running in every 2 mins and failed due to any reason .it will fire multiple alert ,I would like to restrict the limit of the specific failure

    solution :as we work in the shifts , I want it should not come more then 3 time which is in 8-9 hours duration .when I am setting the limit then it will impact to all server not the specific one . whereas I would like to check this monitor based on the time and then fire the alert

    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 →
  5. Estate Disk Usage Emailed Report

    It would be great if we could schedule an emailed report of the disk usage estate section.

    8 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. Allow custom DML script deployments to show on SQL Monitor (like SQL Compare)

    Write now, when you deploy with SQL Compare it puts this wonderful little tick mark in SQL Monitor to show the deployment location and time. We would like the ability to do this with SQL Multi Script or even manually via manual deployments.

    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 →
  7. Filter out Long Running Query alerts based on wait type

    We have a 3rd party product that has a SQL Database. It has something in it that loads data RBAR (Row-By-Agonising-Row). The query gets all the data in about 3 seconds and then sits waiting on ASYNC_NETWORK_IO for ages (close to 40 minutes).

    We don't want to exclude the application from all long running query alerts, and the query is different everytime which would make it hard to filter based on regex (and not filter other queries we care about).

    We'd like a way that we can not raise a long running query alert if it's waiting on ASYNC_NETWORK_IO

    8 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. date format

    I'd like to have an ability to set date format according to the country where the monitored SQL server is in, e.g. USA where date format is MM/dd/yyyy vs UK as dd/MM/yyyy. Also, why not to read and set date format off of the monitored server? Please make it configurable and country compliant so to speak..

    Thanks,
    Yuriy

    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. Group sql server instances at the instance level, not at the server/cluster level

    I would like to control the group that an individual sql server instance is in, rather then having to group things at the server/cluster level. The group views and control over alerting is great, but in the event that the same cluster/server hosts a dev and production instance, or multiple instances that are managed by different members of a DBA team,the usefulness really suffers.

    2 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 →
  10. SQL Agents Job Display Time Windows that Jobs are executing

    The SQL Agent Jobs screen is a great way to track all jobs across all monitored servers. I think it would be helpful to see the gaps of time that no job is running to help determine maintenance windows and also make sure that the jobs are properly spaced out.

    8 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. Performance graphs on disk space alert page

    When we get to the disk space alert details it shows -as with all alerts- a bunch of performance graphs like CPU utilization, disk queue length etc... I think the most relevant graph is missing for this particular case. It would be much more interesting to get a quick glance of the disk space growth over the last 24 hours or couple of dyas for example

    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. Support SAML for Web Single Sign-On (SSO)

    SQL Monitor should be able to support Enterprise Single Sign-On using SAML. Is this on the roadmap?

    22 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 →
  13. Have more flexibility in Maintenance Window Schedules

    We do OS and SQL Server patching one Sunday a month for dev and QA and the following Sunday for production. I think if maintenance windows scheduler looked more like setting a schedule in an agent job it would be perfect for setting these kinds of maintenance windows. And if we could drive setting / modifying maintenance windows via T-SQL that would be even better.

    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 →
  14. Estate Backup Emailed Report

    I really like the new backup feature in the estate section; however, I would love to have this emailed on a scheduled basis. If the email could have a graph like the first sheet and the spreadsheet attached, it would be great.

    2 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. suppress emails during maintenance window

    Allow the ability to suppress all alert emails during a maintenance window. Right now we have ~65 SQL servers and during windows when the OS team is patching and rebooting the servers we can receive 100's of emails as the servers go up and down. It would be great if we could set a schedule or at the very least a single use window when emails don't get sent.

    2 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 →
  16. User Defined Analysis Templates

    Wouldn't it be nice to have the option of saving a view of multiple counters under Analysis?

    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. export the overview page

    The reporting is very limited and provides less detail that the overview and estate pages. We need to be able to export the overview and estate pages easily. Also need to be able to report on the Top queries and top waits.

    4 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 →
  18. Allow for the conversion of time to to HH-MM-SEC in the Duration column on the Server Overview Page

    Its difficult to always have to convert milliseconds, so it would be very handy if this conversion was an option to be included.

    12 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. Include Drive Name on disk related graphs

    A while back per "Disk Names in Overviews and Analysis" the disk/drive names were included some areas but it would be helpful to be consistent and have them included in all disk/drive related graphs.

    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 →
  20. Have a long running SQL Agent job alert

    I found a custom metric for a single long running job. However, what we need is a way to alert for SQL Agent jobs that are running beyond a designated time (similar to the long running query metric built in). The "unusual duration" alert doesn't quite do what we need. Hopefully someone knows how to make this a custom metric. If not, consider a feature request!

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

Suggestions

Feedback and Knowledge Base