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.


728 results found

  1. Show when a Windows/SQL patch was applied

    The current SQL Estate Monitor will show activity for a specific server and has the ability to show when code for example was deployed. I mentioned at the recent SQL in the City in London that it would be good to see any kind of patching that had been applied to that server as well. Get quick eyes on anomalies after a windows update or SQL patch.

    2 votes
    How important is this to you?
  2. Capture cursor SQL for long running queries

    It would be great if SQL Monitor would capture the SQL statement being executed for long-running cursors. Currently it shows "FETCH CURSORNAME001"

    Cursor SQL can be found with this query when the cursor is still open:
    SELECT c.sessionid,
    c.cursor
    id,
    c.properties,
    c.creationtime,
    c.is
    open,
    c.fetchstatus,
    c.dormant
    duration,
    s.logintime,
    t.text
    FROM sys.dm
    execcursors (0) c
    JOIN sys.dm
    execsessions s
    ON c.session
    id = s.sessionid
    CROSS APPLY sys.dm
    execsqltext(c.sql_handle) t

    14 votes
    How important is this to you?
  3. Analysis graph exclude set times over long time range such as 28 days

    It would be great to be able to set exclusion times such as the "maintenance windows" when index maintenance activities take place such as every day between 12pm-2am in our case. During these times disk queue length will be predictably high due to the maintenance activities taking place.
    When viewing graph analysis for a 28 day period for disk queue length you see peaks which are from the maintenance activities and these events end up skewing the overview of BAU activity.
    It would be great to be able to define an "exclusion time window" in the analysis report window to…

    14 votes
    1 comment  ·  Admin →
    How important is this to you?
  4. Allow maximum number of email notifications in a 24-hour period alert to be sent to another email address

    Currently if too many alerts for a particular object are received an alert email is sent noting that no more emails will be sent. I want to be able to specify that email is sent to a different address than the default.

    For example, we may get a large number of deadlocks. after the first 150 the alert emails are silenced. We configure deadlock alerts go to our normal email address because generally they aren't urgent, however when 150 or more are received there is a definite problem that needs to be reviewed. That should go to our pager email…

    9 votes
    How important is this to you?
  5. Add a summary tile for deployments to a database

    I'd like to see a summary tile for deployments to a database by SQL Compare and SQL Change Automation.
    Also it would be good if alerts can be created for these events.

    3 votes
    0 comments  ·  Admin →
    How important is this to you?
  6. See who is using SQL monitor

    Before I upgrade SQL Monitor I'd like to see who is logged in/using it so I can inform them.

    2 votes
    How important is this to you?
  7. Search for SPID for specific Date and Time

    I would be a good idea to have a functionality in SQL Monitor to search for SPID for specific Date and time. This will help us to review what query run by who on given date and time.

    1 vote
    0 comments  ·  Admin →
    How important is this to you?
  8. rss

    RSS Feed, can it be exposed so logon to SQL monitor isn't needed

    1 vote
    0 comments  ·  Admin →
    How important is this to you?
  9. Notification

    Generate Notification Per Alert (optional) and Show in windows
    when Browser is Close.
    And then Send Text Message To User Mobile Number

    1 vote
    0 comments  ·  Admin →
    How important is this to you?
  10. Change unable to connect error messages to include DNS issues

    Added a server via IP address as it's in a remote DC, test ran fine. After clicking Add to monitor the server, SQL Monitor resolved the IP to the cluster name, and attempted to add the 2 cluster servers via name (which is great, much easier to recognise servers via name than remember the IP), however SQL Monitor failed to connect, with WMI errors, RPC Server unavailable etc.
    These errors were misleading, as the real reason it wouldn't connect is that the server couldn't resolve the DNS names. Adding them to Hosts file sorted it straight away.
    Connecting should attempt…

    3 votes
    0 comments  ·  Admin →
    How important is this to you?
  11. provide a scale on the analysis graph when monitoring disk reads and writes

    provide a scale on the analysis graph when monitoring disk reads and writes

    1 vote
    0 comments  ·  Admin →
    How important is this to you?
  12. on the overview, monitored instances be able to choose which groups to show

    It is possible to choose one or all groups on the monitored instances overview. I would like to be able to select more than one group to show or deselect some groups that I do not want to see.

    3 votes
    0 comments  ·  Admin →
    How important is this to you?
  13. Provide a direct link to the base monitor download

    When installing updates, only the SQL Monitor web service link is initially provided. In order to get access to the SQL Monitor base monitor download one has to first install the the SQL Monitor web service. This process slows down upgrade time and extends the "broken state" time in a multi-base monitor configuration.

    Please provide a direct link to the base monitor download without requiring an initial WebService monitor install.

    4 votes
    How important is this to you?
  14. Have database sessions displayed with the networking info from sys.dm_exec_connections(SqlServer)

    Having a window of session connection information, especially using the network info per session as seen in the sys.dmexecconnections view from SqlServer would be very helpful. This also helps in associating network latency waits with the actual app session(s).

    4 votes
    How important is this to you?
  15. Be able to set an Alert to escalate when it has been active for a certain amount of time.

    I have a several different Jobs that fail periodically, once in a while is not a big problem but when they continue to fail over a period of time it does become a problem and I need to know. Likewise when I have an AG is slow to sync in the middle of the night when it is rebuilding all of the indexes of a 1.2TB database and syncing across to locations in 2 states I don't want to be paged, but if it is persistent through the day I do.

    1 vote
    0 comments  ·  Admin →
    How important is this to you?
  16. Showing Unlicensed and will not allow you to stop monitoring

    I added a server that I needed to monitor for a couple hours. When I was done, I swapped out the license and attempted to pause the monitoring to remove the blue banner at the top:

    You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts.

    However, I was unable to pause the monitoring as it just refreshed the page, with the blue bar at the top, and the "pause monitoring" button still enabled and "resume monitoring" button still disabled. Ideally, there would be a way to say I don't want to monitor this server…

    4 votes
    How important is this to you?
  17. Analysis Graph Tab

    This is about the Statistics for the Disk avg. read and write metrics.

    There are times when based on the results for a server the statistics are presented in seconds. More often than not it will be 0.0, 0.2 sec, etc.

    This is not very helpful, and I often find myself having to download the Export (csv) and get the average.

    It would be much more beneficial to just show all results in milliseconds, or present an option to the end user of seeing ms or seconds.

    Thank you

    3 votes
    How important is this to you?
  18. Group alerts into a hierarchy

    I want to be able to group alerts into a hierarchy so that for instance when a server goes offline, all of the other alerts generated such as instance unavailable are not generated.

    3 votes
    0 comments  ·  Admin →
    How important is this to you?
  19. Set up multiple custom alerts for a single custom metric

    For some custom metrics, the ideal number is not a fixed number. (E.g. ideal number of VLFs depends on log file size). In those cases I write a custom metric that returns a "percentage of ideal number". I like to be warned both when the actual number is too high and when it is too low so I would like to set up two custom alerts for this.

    This is currently not possible without creating a copy of the custom metric, which of course wastes resources. Please consider adding the option to set up multiple custome alerts for a single…

    7 votes
    How important is this to you?
  20. I would like to be able to install an update without having to change the browser port.

    I start with port 8080, when installing an update the port is "in-use" so I have to switch to port 8081, with the next update I switch back to port 8080.
    Surely the update should be smart enough to see there is a running process and either disable the web process until the update is finished, or make the update without having to change the port

    1 vote
    0 comments  ·  Admin →
    How important is this to you?
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base