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.


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

647 results found

  1. Make alert configuration levels more discoverable

    CONTEXT: In SQL Monitor, you can configure alert behaviour down to the object level (such as the Database or the Job level). This is useful e.g. when we have specific databases with different backup policies to our global configuration, since we can specifiy "special rules" for individual databases.

    PROBLEM: It is counterintuitive how to do so, and many people don't spot the left-hand drilldown navigation - this makes you think that you can only configure on the global and the server level! Also, when we have created an override, it's easy to forget so causes surprise when we change the…

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

  2. Exclude queries from top 10 queries

    I would like to be able to exclude specific queries from Top 10 Queries. We use SQLQueryNotificationService which means our top 10 queries based on duration are always showing these queries as they have a waitfor. I would like the ability to exclude items from the top 10 queries.

    Typical query I would like to able to exclude:
    WAITFOR(RECEIVE TOP (1) messagetypename, conversationhandle, cast(messagebody AS XML) as message_body from [SqlQueryNotificationService-07e6439b-8276-45aa-963f-bed011b3ef2f]), TIMEOUT @p2

    164 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…)
    5 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. Install SQL Monitor without needing to provision a (large) SQL Server database

    CONTEXT: One challenge with installing SQL Monitor is that we need to provide a connection to a SQL Server database.

    PROBLEM: This can be costly or complicated. It would be better if SQL Monitor had an alternative backend.

    EXAMPLE SOLUTIONS:
    • Offer a hosted data store
    • Automatically deploy a free backend alternative such as mongoDB or PostgreSQL
    • Reduce data collection so that SQL Express can be used for small deployments
    • Provide greater granularity over data retention policies

    What do you think about these solutions? Got another idea? Let us know in the comments!

    150 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…)
    32 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
    Adam responded

    We’ve made some improvements in this area but will leave it open so you can continue to give us your suggestions

  4. Deal better with extremely spikey data

    CONTEXT: Some counters displayed by SQL Monitor is extremely spiky. SQL Monitor scales its graph such that the any spike fits on the y axis

    PROBLEM: If there is one extreme spike, all the other data gets scaled such that it's very close to the x-axis, making any patterns in the data hard to see.

    EXAMPLE SOLUTIONS:
    • allow to manually zoom into the y axis
    • allow extreme spikes to be beyod the drawing area of the graph (still with some indicator of how high the spike is)
    • have an option to show the graph on a logarhithmic…

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

  5. Per database table fragmentation.....

    I would like to see a a Sql Monitor "information" page that shows the "top 10" fragmented tables on a per database level.

    108 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…)
    2 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. Suport for Azure SQL Hyperscale

    Add support for the new Azure SQL Hyperscale PaaS solution

    106 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

  7. Use extended events instead of trace when trace initialized due to alert

    I have seen a related idea https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/5717202-use-extended-events-for-deadlock-tracing-instead

    However, I'm expanding this. If the SQL version is high enough the trace of current activity should be using extended events instead of a trace, this would reduce the total impact to the server performance while also expanding the available information.

    97 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…)
    7 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
    Daniel Rothig responded

    Thanks for the suggestion – we’ll monitor how popular it gets

  8. Do other tasks than send email on new alert

    It would be nice if it was possible to allow other tasks when a alert is raised. Other tasks which could be called: Script file, url, exe file.

    91 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…)
    under review  ·  18 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. Jobs in calender formart so you can see when they are all schedualed.

    It would be nice if you could see all jobs on the server. Perhaps in a calender format so that you can see when they are schedualed. It would be nice if you could drag and drop so that it changes start times. It would be nice if you could see the job history as well.

    83 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…)
    3 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
    Daniel Rothig responded

    We like the idea – if this idea gains traction, we’ll look into implementing something like this

  10. Dark Theme!

    Would love to be able to have a Dark theme for the UI.

    We use a number of other tools where this is an option and really appreciate the saving of the eyes from the sea of white/ other bright colours.

    77 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…)
    6 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. Search through (closed) alerts for a string.

    It would be great if we could search closed alerts for a string. For example I want to see all the alerts that have included a particular view in the query text.

    (Also include comments in the search)

    68 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…)
    13 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
    Daniel Rothig responded

    We’re looking into this – no ETA at the moment

  12. Simpler Upgrade \ Patch Process

    The upgrade process is a bit long winded. It would be great if the system could be upgraded or patch with a single click. Ideally within SQL Monitor but if not, downloading the file and just selecting upgrade would be great.

    66 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…)
    2 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
    Daniel Rothig responded

    Thanks Phil – we are considering reworking the upgrade process. If this suggestions gains more traction, we’ll prioritise it higher

  13. Add alerting for replication performance

    Include an alert to monitor replication performance. i.e based on the latency reading that you can view in Replication Monitor. The counters for this are "SQL Server Replication LogReader: Delivery Latency" and "SQL Server Replication Dist.: Delivery Latency". I'd like to be able to set the alert priority based on this.

    66 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…)
    4 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. Add additional perfmon counters

    It would be useful to have configurable perfmon counters available in "Analysis" above and beyond the out-of-the-box counters.

    65 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…)
    7 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
    Daniel Rothig responded

    For SQL Server perf counters, you can create a Custom Metric against sys.dm_os_performance_counters. For Machine perf counters, you have to use CLI at the moment

  15. Drill-down from Analysis Charts to Back in Time Mode overview for a given data point

    62 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…)
    6 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. Alerts related to SQL Jobs should show the job name not the job Id

    Process name: SQLAgent - TSQL JobStep (Job 0xECCD1234543A1FA439B02DE3CE12F139E : Step 1)

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

  17. upgrade without reentering credentials

    When you run an upgrade, there should be an option that just uses the current service credentials (i.e. leaves everything as is) instead of having to re-enter them.

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

  18. Drop markers on the graphs and add annotations

    While working on performance tweaks it is customary to consult the analysis reports on a regular basis to see if our changes moved the needle. More often than not the tweaks are released one small batch at a time and it'd be nice to drop markers and custom annotations directly on the charts. I'd like to use that feature to add short phrases describing what was changed that led to the improvement, or degradation for that matter, of performance.

    This would be by server (cluster/node) and by metric with the same retention period as the base data for that chart.

    …

    59 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…)
    5 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. Save and Export/Import sql monitor settings

    Setting up custom alerts and servers is quite a bit of work. For example some jobs are more important than others. A different set of people get notified for some jobs. I have setup custom alert settings on many of the jobs this way. recently I had to move monitoring host to a different server and replicating same settings took me a lot of time. hence need ability to be able to export settings from one server and import to another. May be this will work through the monitoring database but I had to change the database from 2008 to…

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

  20. Run a custom SQL script when an alert is raised

    We use SQL monitor very heavily for our SQL and application monitoring, what we would like is for each alert to be able to define a custom sql script to run when the alert is raised, the output of this sql should be included in the alert.

    This would allow us to do things like capture whoisactive when blocking occurs or other application specific things and make responding to alerts MUCH easier.

    57 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…)
    5 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
← Previous 1 3 4 5 … 32 33
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)