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.

  1. Triage and configure repeating alerts more efficiently

    CONTEXT: Some alert types such as Long-running queries, Job Failure or Error Log Entries can trigger very frequently under certain circumstances.

    PROBLEM: This causes a large number of alert emails to be sent, and the only way to ascetain that all these alerts are the same is to view the details screen for all of them.

    EXAMPLE SOLUTIONS
    • Group similar alerts in the alert inbox
    • Raise alerts not on individual events, but on these events happening a specified number of times
    • Mention identifying information sooner: e.g. directly in the alert inbox
    • Suppress query-based alerts for specific…

    463 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    61 comments  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  Adam responded

    We are currently implementing an API to help with bulk configuration of alerts and notifications. If you’re interested in giving early feedback and helping shape the direction of this, please reply and I’ll get back to you with further details.

    Thanks
    SQL Monitor Development team

  2. Custom reports against alerts, queries and metrics

    CONTEXT: We want to see the bigger picture arising from the data presented in SQL Monitor.

    PROBLEM: Currently you can't pull together a report in the SQL Monitor UI, and the monitoring database is not particularly accessible. We need reports against:
    - The metrics shown in the analysis graph
    - The top queries and waits
    - The alerts raised over time
    - Server configuration and SLA

    EXAMPLE SOLUTIONS:
    - Provide reporting scripts against the monitoring database
    - Privide a BI interface against the monitoring database
    - Priovide richer data-export functionality in the UI
    - Provide a report designer in the…

    256 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    56 comments  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  Adam responded

    Version 6.0.17 of SQL Monitor has been released and features enhancements to the reporting beta, now allowing you to make a copy of a report. Version 6.0.16 previously added a new summary tile for Server Waits by day and made improvements to the scheduling.

    If you have any further feedback or details about your specific requirements, please comment or email sqlmonitorfeedback@red-gate.com so that we can consider them as we continue to develop the feature.

    Thanks, Adam

  3. Suppress performance-related alerts during maintenance periods

    CONTEXT: I expect my system to slow down during routine maintenance tasks, which often leads to false postitives for performance-related alerts (long-running queries, High CPU...) in SQL Monitor.

    PROBLEM: While I could configure a maintenance window where alerts don't get raised, this would also suppress operational alerts (e.g. Machine unreachable, Job failed) - these are still relevant while maintenance is in progress

    EXAMPLE SOLUTIONS:
    • Allow to configure maintenance times for individual alerts
    • Change maintenance window behaviour so that operational alerts are still active during maintenance

    What do you think about these solutions? Got another idea? Let us know…

    230 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    24 comments  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Adam responded

    We released an improvement in 5.0 .7 so that SQL Monitor now only suspends performance-related and custom alerts during maintenance windows. All other alerts continue to be raised as normal.

    We plan to review the solution of allowing configuration of maintenance times for individual alerts and will update accordingly.

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

    166 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    40 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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!

    144 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    31 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Adam responded

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

  6. Integrate SQL Monitor notifications with devices, ticketing systems and and other monitoring tools

    CONTEXT: SQL Monitor is one of multiple tools I use to monitor my estate, such as SCOM, Tivoli, and OpenView. I would like to consoldate notifications from all of these tools

    PROBLEM: SQL Monitor only sends human-readable email notifications, but other integration points like SNMP traps are not provided out of the box

    EXAMPLE SOLUTIONS:
    • Provide an SNMP demon against SQL Monitor's alerting data
    • Make SQL Monitor send SNMP notifications out of the box
    • Ability to send SMS or other push notifications
    • Ability to "forward" an alert into a ticketing system

    127 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    22 comments  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  Adam responded

    Version 6.0.7 has just been released and contains beta support for Slack and SNMP integration for alert notifications.

    We’re interested to hear your feedback on this.

    Thanks
    SQL Monitor Development Team

  7. Make SQL Monitor scale to more machines and networks

    CONTEXT: We want to monitor many different servers in different domains and locations

    PROBLEM: Network configuration for cross-domain monitoring can be challenging, and SQL Monior can slow down if many servers are being mointored

    EXAMPLE SOLUTIONS:
    • Create a central web interface that can access multiple Base monitors
    • Provide an optional agent that can be deployed for easier network configuration
    • Make a single installation of SQL Monitor scale to a larger number of servers, and make network configuration easier

    126 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    21 comments  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  Adam responded

    Version 7.1.2 is now available and features a beta for the ability to install multiple base monitors with a single UI.

    Documentation can be found here: https://documentation.red-gate.com/display/SM7/Multiple+base+monitors

    We’d really like to get your feedback if you try this out, so we can get an idea of how many people are using multiple base monitors, and where we can improve it.

    Please email sqlmonitorfeedback@red-gate.com with any feedback, or if you have any questions we can help with.

    Thanks,
    Adam

  8. 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) message_type_name, conversation_handle, cast(message_body AS XML) as message_body from [SqlQueryNotificationService-07e6439b-8276-45aa-963f-bed011b3ef2f]), TIMEOUT @p2

    123 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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…

    108 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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.

    83 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Multiple Maintenance Windows

    I would like to be able to set two maintenace windows every day.

    80 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    10 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Rothig responded

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

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

    77 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Rothig responded

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

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

    76 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    16 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Adam responded

    We were initially a bit sceptical about this, reasoning that if your monitoring solution becomes an active part of the system, it’s no longer a monitoring solution but part of the infrastructure that needs to be monitored.

    However, our thinking in this area has evolved and we can see there are a number of scenarios where it would be useful for alerts to trigger an additional action, and where potential risks are nevertheless manageable.

    If you’d like to help us understand more about the kind of things this might help achieve, please email sqlmonitorfeedback@red-gate.com and we’ll get back to you.

  14. One-time Maintenance Window

    We perform updates to (nearly) all our Windows servers on our domain monthly. I'd like see the ability to set a maintenance window and have it removed once it has passed, rather than having the maintenance window fixed to set time every week.

    One use case is "silencing" alert generation while investigation is in progress

    69 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    9 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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.

    64 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Notifications support for Microsoft Teams

    Just like Slack (Webhook) notification support, it would be great if SQL Monitor could send notifications to Microsoft Teams.

    62 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Long-running query alert - add an option to exclude queries based on the USER running it

    This alert already has the options to exclude queries (via RegEx) based on the process name or SQL commands/objects used. I miss a similar option for excluding queries based on the user running the query.

    An example: let's say you have a job that runs SSIS job steps using a proxy->credential->dedicated domain user. The SSIS packages run loads of SQL queries, some taking a long time - but that might be expected and OK (let's say the job is a nightly ETL process for a DW). Without excluding queries based on that user (simple but effective!) you could get a…

    61 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Rothig responded

    We’re a bit sceptical about this one – with two RegEx fields, this alert already causes a fair amount of time overhead and cognitive load to get configured.

    I’ll leave it open and see how it develops

  18. 61 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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)

    60 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    12 comments  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Rothig responded

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

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

    59 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
    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

← Previous 1 3 4 5 21 22
  • Don't see your idea?

Suggestions

Feedback and Knowledge Base