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.

728 results found

  1. Get the proc name from a deadlock alert

    The Alert gives objectId and databaseid but your average 'accidental DBA' doesn't know the command

    select OBJECTNAME ( objectid [, database_id ] )

    Perhaps somehow suggesting the command as context sensitive help?

    30 votes
    2 comments  ·  Admin →
    How important is this to you?

  2. Reduce false positives due to log shipping / Mirroring

    On secondary server for log shipping/mirroring false positives can be generated for overdue backups/databases unavailable. If these technologies are used for DR purposes then having the checks ignored is unsafe. It is trivial to filter these out with the below code and I'm sure there is something similar in place for Availability Group databases already.

    SELECT *
    FROM sys.databases
    WHERE name NOT IN (SELECT secondarydatabase FROM msdb.dbo.logshippingsecondarydatabases UNION SELECT dbname(databaseid) FROM msdb.sys.databasemirroring WHERE mirroringrole_desc = 'MIRROR')

    18 votes
    0 comments  ·  Admin →
    How important is this to you?

  3. Filter "Blocking Process" alert by User or Application or Database

    We frequently get high-severity "Blocking process" alerts via email for a SSRS database that I'd like to ignore. We sometimes get so many alerts that the new SQL Monitor sends, "You've received more than 30 of these alerts in the past 24 hours so we're going to stop sending them for a while." Unfortunately the alerts caused by the SSRS database mean our Inbox is full of noise and we miss our important application database alerts.

    Please add the ability to filter which User/Application/Database cause these alerts to be raised, similar to some other alerts that support Regular Expression filters.

    14 votes
    0 comments  ·  Admin →
    How important is this to you?

  4. add the table schema to alerts

    On that alert (fragmented index), you see a table name. It would be helpful to see the schema to which that table belongs.

    Medium Fragmented indexes

    Raised on: XXXXXXXX > RedGateMonitor
    Time raised: 26 Jun 2016 1:00 AM (UTC-04)
    Details
    Database name: RedGateMonitor

    Total number of indexes: 332
    Indexes above fragmentation threshold: 3

    Indexes last checked: 26 Jun 2016 1:00 AM
    Fragmented indexes:
    Index Table name Fragmentation(%) No. of pages
    ClusterSqlServerServerWaitsUnstableSamplesIdCollectionDate ClusterSqlServerServerWaitsUnstableSamples 96 1175
    ClusterSqlServerSqlProcessUnstableSamplesIdCollectionDate ClusterSqlServerSqlProcessUnstableSamples 96 3288
    ClusterSqlServerTopQueriesUnstableSamplesIdCollectionDate ClusterSqlServerTopQueriesUnstableSamples 99 1758

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

  5. 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/monitoring-your-sql-sentry-data-with-power-bi/

    20 votes
    0 comments  ·  Admin →
    How important is this to you?

  6. Monitor if all SQL Server related Windows services are running, especially Redgate SQL Backup Agent.

    I have found that backup jobs fail, due to SQL Backup service not running. Knowing that the service has stopped would be a great metric to have. This could then be extended to monitor other Windows services.

    9 votes
    0 comments  ·  Admin →
    How important is this to you?

  7. Check the plan cache ad-hoc or on a schedule to report issues

    implicit conversion,
    scans,
    lookups and the index that didn't have the columns include
    missing indexes
    Parameter sniffing
    etc...
    Report the issues based on impact number

    2 votes
    0 comments  ·  Admin →
    How important is this to you?

  8. Login via https

    Is there a configuration setting to force the SQL Monitor login page (or entire site, preferably) to https?

    10 votes
    2 comments  ·  Admin →
    How important is this to you?

  9. Alert Stats on the new Cards

    Those new cards look very nice, BUT, they do not show anything about the alerts raised on the instance!

    That's a shocking omission, IMO.

    Please add something that shows the alerts, like the old Overview page did, like counts by severity, with colors!

    3 votes
    0 comments  ·  Admin →
    How important is this to you?

  10. Click on CPU part of the server block on global dashboard (version 5.2) leads me to serveroverview instead of graph

    I would suspect to go to the graph (analysis tab) after I click on the CPU part of a serverblock (in Global Dashboard), instead of the server overview

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

  11. Additional parameters for filtering Long-running query alerts

    Long-running query alerts

    Example: Creation of ability for you to filter the queries it alerts on based on a regular expression

    Source Ticket:
    https://redgatesupport.zendesk.com/hc/requests/65981

    Possible closely related feature request:
    https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11123559-triage-and-configure-repeating-alerts-more-efficie

    7 votes
    1 comment  ·  Admin →
    How important is this to you?

  12. Configure Data Purge by Server/Instance or at least by Server group.

    I would like to keep production server performance data for a month or more but the dev server data can be purged after a couple of weeks.

    24 votes
    1 comment  ·  Admin →
    How important is this to you?

  13. I only have one SQL Server, take me to the instance Overview instead of global dashboard

    I only have one SQL Server instance, instead of seeing one small bit of info and having to click that in the new global dashboard, take me directly into the instance so I can get relevant info on first login/site visit. Think about your design when we just have one server.

    5 votes
    0 comments  ·  Admin →
    How important is this to you?

  14. I wish the mouse wheel did not automatically modify the date scale in the Analysis graph.

    I can't count the number of times I have unintentionally messed up a graph with the mouse wheel. It is quite annoying to me.

    6 votes
    0 comments  ·  Admin →
    How important is this to you?

  15. Monitor SSAS databases

    I would like to be able to monitor SSAS cubes and data structures in the same fashion as SQL databases.

    53 votes
    3 comments  ·  Admin →
    How important is this to you?

  16. Group / Sort custom metrics

    We have a lot of custom metrics and the current interface is not robust, being able to group / sort metrics in folders or in a tree would be very useful. Also the selection box in the analysis tab is not large enough to navigate a useful number of custom metrics

    5 votes
    0 comments  ·  Admin →
    How important is this to you?

  17. SQL Monitor self update (or one click update)

    Instead of downloading and running a wizard, I would like to see a way for SQL Monitor to self update, or to have a 'one click' update button built in the interface.

    29 votes
    1 comment  ·  Admin →
    How important is this to you?

  18. Quick view of whether Agent is up on all monitored servers

    If I go to the Configuration > Monitored servers tab, I can quickly see if all SQL Servers are up and running. It would be nice to also be able to quickly see if all SQL Server Agent services are up and running.

    3 votes
    0 comments  ·  Admin →
    How important is this to you?

  19. SQL Monitore: I would like to see the response time I/O of database files.

    SQL Monitore: I would like to see the response time I/O of database files. Currently it is showing only on instance level but how can I see response time of a particular
    database.

    11 votes
    0 comments  ·  Admin →
    How important is this to you?

  20. Alert based upon trend data

    We want to be able to alert when a value changes dramatically over a period of time. so if a system returns 110,105,112,40,38,52

    to eye ball that on a graph I can see there is a problem, however that may be at the peak time of the day and 38 might be a reasonable value for in the middle of the night, so having a threshold of a low value is not appropriate, the comparison mode of query for this situation would report a change of
    -5,+7,-72,-2,+14

    in here there is one large drop but then it is running stable,…

    3 votes
    0 comments  ·  Admin →
    How important is this to you?
1 2 … 31 33 35 36 37
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)