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. group similar queries

    I have queries which are created by string concatenation in a legacy product.
    These queries differ by some IDs in a IN clause.

    In SQL monitor, these queries are all shown as different queries in the "top queries" section.

    I would like that all those similar queries are shown as one query in the "top queries" section so that I can better find long running/problematic queries.

    11 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. Add Query Impact metrics into analysis graphs

    Add the ability to report on Query Impact metric in the analysis section to monitor trends.

    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

  3. Offer integration with power bi

    I've love the ability to integrate SQL monitor with Power Bi for building dashboards of analysis graphs. Since Power BI is offering a powerful way to setup dashboards with metrics users/managers care about this would be a great way to enhance many analytical report options by outsourcing the creation of those to users more and more, and offering the integration with power bi to make it easy to do.

    SQL Sentry offers an integration with their cloud product to work with their metrics and Power BI in case you want to evaluate how it might be used. https://www.sqlsentry.com/Company/News-Article/20150505-power-bi-content-pack-sql-sentry

    https://powerbi.microsoft.com/en-us/blog/monitor…

    20 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

  4. Email reports monthly

    I just upgraded to SQL Monitor V7 and it's great being able to have custom metrics in reports. We have a metric that records how many customers are notified in a monthly process (runs overnight on the 1st of the month). We need a way to send out this report via email on the 1st of every month (current options are only to send it weekly)

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

    The ability to email reports on a monthly schedule has now been released.

    Please make a new suggestion if there are any areas of the reporting you think could be improved.

    Kind regards,
    SQL Monitor Development Team

  5. Prompted for update to version 8.0.12 but website is a dead end

    The "update" link in the SQL monitor console takes me to a "learn more" page with no link to an update EXE. I am referred to a zip file with a SQLBundle EXE which doesn't contain the Monitor, or an outdated version of SQL Monitor.

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

    Hi,

    Thank you for reporting this, and apologies that you encountered it. We removed version 8.0.12 owing to a bug, and have since released 8.0.13.

    I will close this suggestion, but if you require further assistance with this issue, please could you let us know using the support forum https://forum.red-gate.com/categories/sql-monitor-7

    Kind regards,
    Adam
    SQL Monitor Development Team

  6. Email Alerts subject info

    Change the subject to the email alert, remove the SQL monitor ID number as taking up space without adding value, making it more difficult to gather the neccesary info from the subject line for job failure etc when viewing email through a portable device iPhone etc.

    6 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…)
    5 comments  ·  Admin →
    completed  ·  Priya Sinha responded

    SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.

    Thanks,
    SQL Monitor Development Team

  7. Tags in "About" section are viewable, but not selectable or copyable

    The tags in the about section in a monitored Server are viewable, but not copyable.
    We use tags for the category or a contact person or person of charge or additional information hints.

    This information as tags are a easy appoachable and fast way to see those information from a sql server.

    But there is no easy way to copy the content of a tag. You can easily drop a tag or create a new tag, but is impossible to select/copy (somehow select + right click + copy or select + ctrl c) the content of a tag.

    …

    6 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. Include instance-specific name (@@SERVERNAME) on alert mails

    The alert mails for a SQL Server cluster contain the cluster name but not the actual instance virtual name. It would be nice if the mails contained the actual virtual name (as given by "select @@servername") so that the email contained all the details needed to connect to an alerting instance.

    My cluster name (i.e. CLUST01) is a different IP than my virtual names (i.e. VIRTUALSQL01), which means that I can't connect to my "FOO" instance by "CLUST01\FOO" as the alert email seems to indicate. Instead I need to connect via "VIRTUALSQL01\FOO" which is not present anywhere in…

    20 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. Raise Free Space alerts on disks that are mounted, rather than simply drive letters/volumes

    In our clustered environments, instances are given a small drive for mounting the larger data/log/etc volumes within them.
    Whilst we always get a "disk full" warning on the mountpoint drives (subsequently disabled), there appears to be no ability to monitor the volumes that are mounted within, where we do care about free space.
    I do see that metrics for IO, latency etc are done on a per volume (not drive letter) basis, so would be great if we could have consistency.

    12 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. Show 1 hour time on timeline

    Show 1 hour time on timeline, 6 hours is too loong for frequent databases

    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. Set database file usage per drive level on the DATABASE LEVEL

    , i know we can set database file usage per drive level on the server level. But there are many times when a vendor created db, they have multiple data files mdf/ndf and have them set to limits. So i was wondering can we get even more granular. I want to be able to drill down to the database and select a particular file group and say ignore this drive, it has met its capacity and even though its 100% filled data is no longer being written there. And the reason behind that is there can be multiple data files…

    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

  12. Allow the pinning of availability groups to the Global Dashboard

    I'd like to see the status of my AGs on the Global Dashboard without having to find them inside the server. Would also nice to see stats on latency on this widget.

    6 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 →

  13. Choose aggregation used in the analysis graphs

    (Posting for a user)

    Would it be possible to request a change to the graphing data algorithm to allow for the user to select (when adding a metric to the analysis graph) whether to use AVG (mean) aggregated or MAX aggregation. Although you could allow for any of the aggregation operators to be used, see screen mock up below from the SQL Monitor Analysis tab where you add the metrics to the graph.

    I think it would significantly enhance the analysis of peak (local or global maximums) and it would prevent peak values being artificially dragged down to a local…

    25 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 →
    declined  ·  Daniel Rothig responded

    Unfortunately this is a fundamental constraint of sampled data: The peaks you see in SQL Monitor are the result of spaced sampling as well, and are therefore (informartion-theoretically) no different from the average aggregation that you see when you zoom out in SQL Monitor.

    We could make it so that when you zoom out, we show you the highest data point in our data set, ie. the highest partial average, but that’s not really mapping to anything real, so would be quite misleading

  14. Show Job Description in Job Alerts

    I'd like to see the job description in job alerts. We use this field in sql server to add notes about what the job does, who to inform on failure and rerun steps.

    6 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

  15. Requirement of more reports as described below

    Can have the following reports

    1)fragmentation level of the indexes in all the databases in all the servers .It can be tabular format with each of the current information as column and all servers and its info as row

    2) Server summary for all the servers (in a table format )

    3) Replication status of all the servers in the estate

    4) Permission of users in dbs in all the SQL Instance

    5) To see the compliance level based on a CU or patch for all the servers . It is more like I can…

    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

  16. Schema name in the Indexes tab and Top procedures tab on the overview page

    In SQL server it is possible to have indexes with the same name on different tables. It is also possible to have tables with the same name on different schemas. Therefore, you can have indexes with the same names on tables with the same names on different schemas. The same is true for stored procedures.

    Since there is no data on the index and stored procedure's schema in the Indexes tab and Top procedures tab on the overview page, one does not know which exact SP or index is in the table.

    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…)
    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. Save DMV Snapshots for Analyzing and monitoring changes

    Idea is to save snapshots of DMV's so that the changes can be analyzed. For example sys.dmexecprocedure_stats shows only total, last and average elapsed time. It will be great to know how the average changed over a period of time.

    Common use case: sysproperties

    31 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. Re-Check an alert

    It would be helpful to have a "ReCheck Monitor" button for all of our alerts in Monitor. We have some checks that are only performed once per day. When those checks create alerts, we make quick work of resolution, but the alert doesn't clear for a long time (next day). It would be very helpful to have a button to force an immediate re-check. This would validate the fix and get us back to an all-green status quickly.

    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

  19. Mask sensitive data from deadlock and top queries

    We want to let developers use SQL Monitor, but for that sensitive data has to be masked. Two places that come in mind where we can things like literals in WHERE clause etc are deadlock and top queries. This would ideally be combined with a security group which which the masking should apply.

    6 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

  20. Search by Query hash in Top queries

    As discussed in https://forum.red-gate.com/discussion/91306/search-by-query-hash-in-top-queries/p1?new=1
    it would be very useful to be able to search by Query hash in Top queries.

    Scenarios:
    - for complex (and parametrized) queries it may not be enough to be searched by QueryText, DatabaseName or ParentObjectName;
    - if queries impact is also investigated and tracked in external systems the QueryHash may be (the only common) field to quickly identify and find that query in Redgate Monitor.

    10 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
1 2 … 20 22 24 … 36 37
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)