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. Index on msdb..backupset

    One of my servers has a db with many filegroups and does log backups every 5 min. For this reason the msdb..backupset table is very big and SQL Monitors query
    SELECT DBNAME(DBID([databasename])) AS [DBNAME(DBID([databasename]]))], MAX([backupfinishdate]) AS [MAX([backupfinishdate]])], MAX([backupstartdate]) AS [MAX([backupstartdate]])], [type] AS [[type]]] FROM msdb..backupset WITH ( NOLOCK ) WHERE DBID([databasename]) IS NOT NULL GROUP BY DBNAME(DBID([database_name])), [type]

    reads ~3,500 pages per execution (CLUSTERED INDEX Scan) -> one of the TOP 10 queries (at least in the night :-)).

    The…

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

    Sorry, we can’t add indexes to our users’ production servers to speed up our queries!

  2. The "Output" area for Deadlock events should be resizable

    When viewing a Deadlock event, you can go to the "Output" tab to get details on what T-SQL was running when the deadlock occured. However, that window is quite small, and is not resizable.

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

    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 →
    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. Word Wrap Alert Comments

    Super minor detail, but it would be a more pleasant experience if I didn't have to use a scroll bar to read comments on Alerts. If it were word wrapped in some manner it would make the user experience better for me.

    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…)
    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

  5. Have ability to configure alerts to be active for various periods.

    I have multiple alerts (including custom alerts) on serves. I would like to configure alerts to have different thresholds for diffident periods (weekday/ weekend) OR (mornings / evenings ) OR other periods.

    Like log sizes on weekends (mostly due to index maintenance) can be much higher than weekdays.

    Current "alert suppression windows " applies to a host and to all alerts on it and not to specific list of alerts.

    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

  6. Provide Managed identity as an Authentication Method to the Redgate Azure SQL DB

    Support for using the managed identity of the Webserver/Applicationserver VM to authenticate over the AAD on the Azure SQL Redgate Database.

    -> Maybe also Support for Azure App Service which has built-in this functionality?

    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

  7. compare different times in analysis graph

    We have upgraded SQL and changed servers for one system It would have been nice to compare in the same graph different timeslots and different machines

    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

  8. Pass tags through the webhook json

    I would like something like {{Target-tag}} to pass through the webhook, this will allow us to better spilt the alerts to the correct team on the other side so that 1 team isn't having to get all the alerts, but using other integrations and wrokflows with something like a tag we can spilt the alerts to different teams based on target and severity, but also with shared servers the tags will allow us to spilt those alerts as well.

    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

  9. Navigation for "rewind time" shouldn't hide navigation buttons

    The navigation controls for "rewind time" autohide when actively using this feature. Please consider enabling until "live" is chosen again to simplify operation to move back and forth in time increments.

    Issue submitting first time. if duplicate please close.

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

    Closing this because the v6 server overviews no longer have this particular time control so hopefully this bug is no longer relevant.

  10. Estate Licensing - Align with Microsoft HA/DR Licensing policy

    Estate licensing appears to tally all licenses for servers in an WFC/HA config. 3 node cluster 4 cores, 12 licenses (when it should be 8). Please provide the process to identify an HA or DR node, which will allow the Redgate Estate portal to align with Microsoft SQL Licensing: https://download.microsoft.com/download/e/2/9/e29a9331-965d-4faa-bd2e-7c1db7cd8348/SQL_Server_2019_Licensing_guide.pdf.

    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

  11. FCI alerts should refer to the DB instance and not to the active node

    For various alerts that are actually assigned to nodes of a Windows FailOver cluster (no AlwaysOn), the alert display shows the active nodes as the source. For example, "Disk average read time" Node1 -> E: instead of the cluster role SQL instance -> E:.

    I can more quickly deduce from the name of the DB instance which DBs or which applications could be affected. The names of the nodes are numbered and meaningless.

    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. Estate Page - Disk Usage - Show Actual with Allocated

    There's plenty of real-estate to include a column for database file rows that shows the true "USED" space, not the Allocated space.

    Right now, SQM is predicting data drive exhaustion at 16 days hence:
    Fake "Used": 5,634.5 GB Capacity: 5,959.4 GB Fake "% Used": 95% Time until full: in 16 days

    Sadly, Untrue, from a "Used" perspective - only true from an Allocated perspective!

    When I drill into that drive, THIS is the truth:
    Used: 4,752.6 GB Capacity: 5,611.7 GB

    Please promote this "USED" as a higher-level total, and use it as a projection - i.e., retain a history of…

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

  13. Produce a long running queries report ordered by average execution time

    I have been tasked with identifying queries with the longest average execution time so that they can be targeted for optimization. In the server overview this can be done in the top queries section, however this obviously only shows queries for that instance.

    In the reporting tab I can create a report for long running queries, but it is based around total execution time. It would be useful if this could be ordered by average execution time.

    A query that runs 100,000 times and takes 10ms will have a higher overall execution time than one that runs 50 times and…

    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

  14. Every alert should be able to be cleared

    I recently ran into an issue where a specific alert ("Monitoring error") could not be cleared. Support staff told me this is by design.

    I thnik this is bad design. Every alert, no matter how serious, no matter how breaking, should be clearable.
    Whatever the issue is, once I am aware it is up to me to decide whether I want to continue to be alerted or not. If I know I'll fix it later, or I know I won't (or can't, as was the case for me) fix it, then I want to clear it.
    By not…

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

    Hi Hugo,

    I’m sorry to hear that you’ve experienced issues with this. There is a setting within ‘Configuration > Display settings’ (see screenshot) to not force errored instances to display red on global overview.

    It sounds like this is the issue that you’ve experienced. If you activate this setting then monitoring errors will not behave in this way on the Global dashboard.

    Neil Turner
    (Lead designer – SQL Monitor)

  15. Wider parameters for reports

    Incorporate ability to run reports for a group of monitored servers for a longer duration. For example: Report of unreachable status on 12 different servers for the past year.

    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. PaaS dbs on an instance appear seperately

    Hi Redgate Support,
    While adding PaaS SQL servers, each database appears individually. Will this change in near future where they appear together with other database on the instance like they do on-prem and on IaaS.

    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…)
    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

  17. Report Email Attachment Name

    Name the pdf attachment something other than "AttachedReport".
    The report has a title and a date which could be used to name the attachment. That would really simplify the process of saving the reports for baseline purposes.
    e.g. "Server2ProcessUtilization20180308.pdf"

    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. User Defined Analysis Templates

    Wouldn't it be nice to have the option of saving a view of multiple counters under Analysis?

    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 →
    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. Show the worst queries per database ordered by CPU

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

  20. Ignore Negative Custom Metric Collection

    I am trying to add a custom metric based on the sys.dmosperformance_counters DMV. These are very useful for gaining Instance Level information. These counters increment as each lock is requested. I have used the “Use a calculated rate of change between collections” option which accurately depicts the graph I am trying to accomplish. The caveat is that these counters are reset to 0 when the instance is restarted. Therefore in any of my graphs, I get this huge negative value. This basically renders the metric useless because I cannot visualize any metrics once a server is rebooted.

    Is…

    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
1 2 … 32 34 36 37
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)