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.

43 results found

  1. Few suggestions:

    • Display the Job Name (character string) instead of hexadecimal value (SQLAgent - TSQL JobStep (Job 0x442BC6B49DA6FC41A98697F8C2F68956 : Step 1)
    • In alerts configuration: Be able to exclude Long-Running query alerts (or any type of alert) for a specific time frame. For example: between 11:00PM and 5:00AM
    • When selecting an alert details view, create a link to be able to come back to previous alerts summary screen instead of selecting Overviews link and then again narrowing down to alerts summary by server let’s say…

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

    Hi, because these are multiple suggestions and it’s not clear who has voted on what, I am going to have to close this suggestion.

    If you are interested in the Job Name request, please open a new suggestion for this

    If you are interested in the Time frame suggestion, please vote on: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122008-suppress-performance-related-alerts-during-mainten

    If you are interested in returning to the Alert Inbox from the details view, this has been implemented in SQL Monitor 3.3

  2. Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them.

    Should have feedback on missing index, its great know that I have a slow running query but some possible hints on how to improve them,
    the infomation is avalible in SQLServer version 2005 onward in the following DMV
    sys.dmdbmissingindexdetails
    sys.dmdbmissingindexgroupstats

    sys.dm    dbmissingindexgroups
    sys.dm    dbmissingindex_columns

    So I still have to go off and check.
    Overtime as database grow in size and data distribution of the tables changes therefore indexing requirements change, so unless you monitor these DMV's you may not notice that an index may be helpful.…

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

    The missing indexes DMVs are not an exact science, so we’ve decided against presenting sometimes-helpful, sometimes-disasterous tuning advice in SQL Monitor.

    However I’m confident that SQL Server itself will continue to evolve as a tuning platform, leaving SQL Monitor free to look at the bigger picture.

  3. Allow Groups to be created on Instance name rather than server name

    For multiple instance hosts, each instance can have a separate functional purpose. However groups do not allow instance level granularity. It would be useful to have distinct instances from the same host in separate groups.

    30 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…)
    3 comments  ·  Admin →

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

  5. Show Stored Procedure Argument values in Long Running Query alerts

    Showing me the CREATE PROCEDURE XXX_sp would be far more helpful if I could see what parameters had been passed into the procedure.

    The run times of some of our procedures vary significantly depending on the client or account they are being run for. Knowing what values were passed in to the SP is essential information in troubleshooting the problem.

    16 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

    Due to our agentless architecture, SQL Monitor cannot do this without incurring a significant performance overhead on the monitored entity.

  6. Export the analysis graphs to PDF and add printing support.

    I would like to be able to print nice well formatted reports from SQL Monitor so that it can be shown to Management. I guess exporting to PDF could accomplish that.

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

    Please use our CSV export instead – Tools like Excel will help you visualise your results in a variety of ways

  7. where is sql server database mirror status

    i want see sql server database mirror status

    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…)
    1 comment  ·  Admin →
    declined  ·  Daniel Rothig responded

    We’ve seen mirroring to be used by a vanishingly small portion of our userbase, and it’s not growing.

    However, you can create Custom Metrics and alerts to get the same information into SQL Monitor

  8. maintenance windows

    To track 'up-time' (probably using a custom metric) which can be used at 3, 6 and 12 month intervals to show the servers uptime accurately. But it would be useful to ensure that data from with the Maintenance Window is not included. Therefore it would be very useful to have the option to either suspend data collection for some or all custom metrics during the Maintenance Window, or even suspend all data collection during the window.

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

  9. Different colours when comparing

    I think it would be easier to differentiate the two lines when comparing (for example today's values with last week's).
    For example Red vs blue lines.

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

  10. Average SQL Duration

    SQL Executions, New metrics.
    Number of statements executed during the current interval.

    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…)
    2 comments  ·  Admin →
    declined  ·  Daniel Rothig responded

    Which queries to include/exclude in this KPI depends a lot on the enviroment – so it’s best implemented as a custom metric

  11. Add Clear, Unclear, Read, Unread buttons to the end alerts list.

    Add Clear, Unclear, Read, Unread buttons to the end alerts list.
    I like to have 100 alerts per page and its very unpleasant to clear several alert that are on the end of the page.

    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 →
    declined  ·  Neil Turner responded

    The ‘Clear’, ‘Unclear’, ‘Read’, ‘Unread’ and ‘Add Comment’ buttons are pinned to the top of the alert inbox list. The buttons are therefore always available as you scroll down the alert inbox.

  12. Disk Space / tempdb / Custom Alerts

    Hi,
    I have couple of suggestions as per my present system architecture ...
    1) For disk space alerts, user should be able to configure this alert for as many disk/drives as user wants out of the total disks/drives are available on the server. If needed, user should also be able to ignore a particular drive. Right now, SQL monitor checks for all the disks/drives on the server
    2) For database level alerts, there should be a exclusive alert for tempdb space
    3) In custom alerts, SQL Monitor should be able to display a resultset of a SQL query and publish…

    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…)
    3 comments  ·  Admin →
    declined  ·  Daniel Rothig responded

    Closing as this is multiple ideas – please raise a separate suggestion for each

  13. Specify databases for custom metric using wildcards

    We have multiple databases for each of our clients - each type of databases uses the same schema and follows a consistent naming convention. For example:

    XXXXMain
    XXXX    Extra
    XXXX_Management

    YYYYMain
    YYYY    Extra
    YYYY_Management

    I want to add a custom metric that only applies to "_Main" schema so in order to choose databases to collect from I need to specify each database explicitly. This proves challenging as the number of clients grows and we add more servers / instances to our environment.

    It would be preferable if i could instead use some form of wildcard to specify databases…

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

    A bit of an edge case that would make things a lot more complicated for all users

  14. Latch Wait Time Explanation

    In SQL Monitor 4.0, the explanation refers to sys.dmdboperational_stats which does not actually exist.

    Should this be sys.dmdbindexoperationalstats?

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

    (not actually declined, but we are tracking this separately as a bug)

  15. Classic Dashboard Mode

    The new global dashboard is great but it is harder to read at a glance then the old dashboard. Please add in a classic dashboard option.

    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 →

  16. Custom metrics in Analysis tab - allow grouping by metric type (machine / SQL Server instance / database)

    In Analysis tab in the metric choice window all custom metrics are currently grouped together and sorted alphabetically. I'd like to see them grouped by type similar to the out-of-the-box metrics (machine / SQL Server instance / database) - the type could be a new parameter for each custom metric, manually entered / changed.
    That would help when one has a lot of custom metrics.

    The result:
    - Machine metrics
    - SQL Server metrics
    - Database metrics
    - Custom machine metrics
    - Custom SQL Server metrics
    - Custom database metrics
    - (maybe also this: Custom uncategorized metrics)?

    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…)
    6 comments  ·  Admin →
    declined  ·  Daniel Rothig responded

    we have found that this is not how people use custom metrics in general, so adding this split by default would go against the practices of most of our users – the best workaround for those that do have this split is to add a prefix to their custom metric name – they are ordered alphabetically

  17. Add scheduling for monitoring suspension and resumption

    Using Azure SQL Database in serverless mode with an auto-pause is a useful feature to save money when the db is not in use. SQL Monitor keeps the db from sleeping overnight.

    Suggest addition of scheduling for Suspend/Resume operations, similar to alert suppression scheduling.

    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 →

  18. Add hide/show button for metric in Analysis Graph page

    Add an ability to quickly hide/show lines of metrics in Analysis Graph. It would be very useful when looking for correlation findings.

    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…)
    2 comments  ·  Admin →
    declined  ·  Daniel Rothig responded

    We tried this out and couldn’t get it to work without making the interactons on the UI more confusing

  19. collect table scan density percentange

    We would like to collect the "dbcc showcontig" table scan density percentage so that we can alert on levels below a certain percentage.

    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 →

  20. Add an index to Alert.Alert on AlertType to remove index scan

    Here's the index. It really helped speed up the system (monitoring 20 servers)

    USE [RedGateMonitor]
    GO
    CREATE NONCLUSTERED INDEX [AlertType]
    ON [alert].[Alert] ([AlertType])
    INCLUDE ([AlertId])
    GO

    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…)
    2 comments  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)