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.


44 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 following index…

    1 vote
    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)
    declined  ·  Daniel Rothig responded

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

  2. The ability to publish custom metrics and alerts to your website for review and easy addition to community driven submissions. I have tested

    The ability to publish custom metrics and alerts to your website for review and easy addition to community driven submissions. I have tested on my own systems and would like to quickly post up the custom metric and alerts I have created instead of current process.

    1 vote
    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)
    declined  ·  Daniel Rothig responded

    Currently we use an email submission system – our sumission volume is still too low to implement an automated process

  3. add custom metric for tracking use of deprecated features

    I think it should be possible, using Extended Events or some other method, to create a custom metric that allows SQL Monitor to track the use of deprecated features. This data is useful for upgrade planning or best practice reviews. I realize some of this can be found via server-side tracing, but I have heard that Extended Events may be more efficient.

    1 vote
    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)
  4. why It splits the server and port

    when I try to add the sql instance to monitor , I have to use port and when I do so it splits into two servers. also host and instance is bit confusing , why it goes as local for anyserver you addd to monitor

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    declined  ·  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)
1 3 Next →
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base