Skip to content

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.


671 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Enhance Reports with additional Summary Tiles

    Different Summary Tiles for example: Servers with lowest Page Life Expectancy, Servers with Highest Transactions/Second, Servers with Highest Disk Transfers/Second,

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  3. nagstamon support

    hi,

    it would be very nice to have support for nagstamon.

    https://nagstamon.ifw-dresden.de/

    thanks.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  4. Include Custom SQL Code in alerts

    When creating custom alerts, I would like to be able to include information that can be retrieved by running a SQL query.

    One example is using the pre-built Failed SQL login custom alert that is available to setup. The alert notifies when this event occurs, but it fails to include information like which login failed, etc.

    It would be nice to be able to build part of the e-mail body in the alert to include some critical data that can be queries using T-SQL.

    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. check if there are any service packs or updates for my SQL Server instances

    check if there are any service packs or updates for my SQL Server instances. This could then raise an alert to prompt me to investigate these updates.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  6. deadlock frame procname text missing final character

    The SQL displayed under the frame procname for a deadlock is missing the final character of the SQL.
    e.g: and #ttable.StartDate is nul
    Should be
    and #ttable.StartDate is null

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  7. enhance Title on Analysis Graph Page with "machine metrics"; "machine name"; (all)

    Simply add to existing title with the selection of dropdown boxes as "machine metrics"; "machine name"; (all).

    So we don't need to scroll down or include the bottom boxes to know which machine and options are being displayed...

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  8. Sharing links

    link share.. . past 24 hours link, you send it, and people click on it, still shows past 24 hours, not the 24 hours from when you shared it

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  9. Allow nested groups on the Overview screen

    I have a structure of groups where the first level is environment (Production, Test, Development, etc) but then I have component as a second level (ETL, Application, Data QA, Sandbox). On the Overview screen, only the first level of the grouping is used, and therefore I have servers under 'Production' all bundled together and ordered by name across all the secondary groups. Would be good if the overview screen could show multiple groups somehow ... I understand there might be servers under the first level and the second level, and it might be weird for some customers ... but for…

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  10. pass

    Platform as a service(PaaS) support on SQL Monitor

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Would like to set SNMP trap eventtime in a localized time format, currently only CET time format (with trailing Z) is sent in a SNMP message

    Would like to set SNMP trap eventtime in a localized time format, currently only CET time format (with trailing Z) is sent in a SNMP message

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  12. Alert statistics over time

    I would like to see which alerts are firing more frequent over time.
    It would be nice to be able to see alert statistics over time, tabluar or graphical.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
    under review  ·  Adam responded

    We’re reviewing this and would appreciate any more context on what you would like to do with the information.

  13. Provide Mobile version of Alert Monitoring Screen

    It may be just me (since no one sle has yet to suggest this) but a mobile friendly version of SQL Monitor for the ALERTS tab would be of great benefit. Currently I check the ALERTS on my SMART PHONE which has a screen waaaayyyy to small to do this but since I have no tablet option I have no other choice.

    A mobile option at login to SQL Monitor would let those with smaller sized computing devices acccess the ALERTS tab so as to monitor/check in on their SQL Monitor instance remotely.

    Thanks

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    under review  ·  Neil Turner responded

    There are currently no plans for a SQL Monitor mobile app. We hope to improve the experience when using SQL Monitor on a mobile device. However at the moment we can’t give a timescale for when this might happen.

  14. Show sample aggregation values on Analysis graph

    As you zoom out of a graph on the Analysis tab, the peaks and troughs become less obvious (I fully understand that and agree), but it would be beneficial to know roughly the level of detail at which the values have been calculated to show on the graph.

    So for example at the most detailed level (say at Last 1hr) CPU usage is sampled every 15 seconds, zoom out to Last 6hr, and the points seem to be every 1 minute - so are 1 minute averages.

    If I come all the way out to a custom 60 day view,…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  15. Show current data sizes on purging page

    On the data purging page would it be possible to show for each of the data categories how much space each one is currently occupying.

    Possibly even an 'oldest date' too? As this may be pertinent if the purge thresholds haven't yet been met.

    On some environments I want to keep as much SQL Monitor data as possible and if it's a healthy server you may have very little alert data, and so want to keep more history than you do say, machine data.

    It would also help in cases where the Repository database is growing, and you're not sure…

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Blocking process alert based on number of descendants

    While the alert for blocking process is great, it would be nice to be able to configure the trigger for number of descendants affected as well.

    If a blocking process runs for 30 seconds and affects 10 people but the alert is configured for a one minute duration of the block it would obviously not let you know

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  17. set the default email recipient per level

    I'd like to be able to override the default email recipient "per level", in the same way alerts can be configured.

    This would make it much easier to manage in a case where monitoring responsibilities are delegated for a specific server or group of servers.

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
    started  ·  Adam responded

    We’re currently working on adding the ability to send notifications to different recipients per level of alert, along with other notification changes. We’d really appreciate some early feedback to make sure we’re on the right track.

    If you’re willing to take a look at our designs and give a bit more detail on your specific requirements, please reply to sqlmonitorfeedback@red-gate.com with ‘Notifications’ as the subject and I’ll send further details.

    Thanks
    Adam, SQL Monitor Development Team

  18. 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)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Add an option to schedule when custom metrics run against a given database.

    Currently when a custom metric is executed can only be controlled by the frequency (daily, hourly, etc).

    My primary purpose is for daily. I would like to schedule the time of day a daily metric is run per database, or at least server. The custom metrics I pull back are time sensitive so controlling when the metric is returned is a must.

    A more advanced option to this would be going beyond simply choosing the time of day for daily runs, but rather the ability to build a custom schedule of run times. An example might be Custom Metric A…

    54 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Custom metrics to have their own individual data purging value

    At the moment, we can only have a single value for data purging for all custom metrics.

    I would like to be able to set a custom data purging interval for selected custom metrics as I'd like to track them over a longer period of time.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base