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.


207 results found

  1. Make cookie timeout duration configurable

    Currently Cookies expire after 2 days, this means you have to re-enter your password for SQL Monitor every two days. This should be configurable. Some of us have adequate desktop security, and secure external access that this is unnecessary.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  2. Traceflag 1222 for deadlocks

    Use traceflag 1222 for deadlocks when monitoring SQL 2005+, and keep 1204 just for SQL 2000 instances. 1222 gives so much more information and doesn't cut off the SQL text.

    48 votes
    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)
    completed  ·  Priya Sinha responded

    Hello,

    We are pleased to annouce that this feature is now implemented as part of v4.0 release. Please check release notes for more details.

    Thanks,
    Priya

  3. Put SQL statements from "top 10" in a textarea box

    I'd like to see the SQL statements in the "Top 10 expensive queries" inside a textarea box so it's easy to copy and paste out of it.... The current layout of putting the SQL in a div makes it difficult to get the SQL out of there to paste into Management Studio to examine

    3 votes
    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)
  4. Change colour of chart line

    When viewing a single metric chart in 'Analysis', the line is a yellow-golden colour, which I find horrible (just my opinion) and hard to focus on - can this be configurable?

    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)
    completed  ·  Adam responded

    This was completed in 3.0 – apologies for not updating sooner.

    We changed the colour palette and improved it. We have still had to use yellow due to the number of dbs it’s possible to display, but it will be used last and is more of a mustard/orange yellow now. We’ve also deepened other colours so the Analysis page should be easier to view.

    We hope this is fixes the problem – thanks for the suggestion – and we welcome any feedback.

  5. Enable and track wait stats

    I would like to see an overview of wait statistics along with historical tracking of those waits. I currently have queries that would show the total wait time, but other tools I have used will provide a current snapshot of these waits as well as store them historically so that I can monitor changes.

    72 votes
    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)
    completed  ·  Priya Sinha responded

    Hi,

    We are excited to annouce that SQL Monitor v4.0 has been released. This release contains Performance diagnostics features which let you analyze the waits and queries affecting SQL Server performance on the Instance overview and Database overview pages. Check out the release notes for more details.

    Thanks,
    SQL Monitor Development Team

  6. Allow filter on Global Overview

    E.g. exclude 'Ended' (but not yet cleared) alerts. (Gives an overview of the current state)

    8 votes
    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)
    completed  ·  Adam responded

    We believe improvements to the dashboard in 5.2 make this no longer valid. Please open a new suggestion if you would like to see further improvements.

  7. Email Alerts subject info

    Change the subject to the email alert, remove the SQL monitor ID number as taking up space without adding value, making it more difficult to gather the neccesary info from the subject line for job failure etc when viewing email through a portable device iPhone etc.

    6 votes
    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)
    completed  ·  Priya Sinha responded

    SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.

    Thanks,
    SQL Monitor Development Team

  8. Ability to store a baseline

    After attending SQL in the city and listening to Grant Fritchey talk about the need to create baselines (and demo sql monitor) a feature I would like is the ability to create a baseline over 24 hours and have it stored. This could be then added to the analysis page as a Versus. ie last hour vs baseline, last day vs baseline.

    118 votes
    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)
    completed  ·  Daniel Rothig responded

    With SQL Monitor v.3.5 introducing a powerful baselining feature, we consider this suggestion as completed.

    One thing our implementation doesn’t do (though it was mentioned in a couple of comments) is to be able to “freeze” a data range so as to retain a static baseline. We’ve created a suggestion for this additional functionality – so if you are interested in that aspect please vote on the following suggestion: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122092-select-and-store-a-static-baseline-for-future-refe

    Thanks
    Daniel

  9. Add an alert to monitor failed logins.

    The sql logs show failed logins, could we have an alert for this?

    15 votes
    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)
  10. add LDAP/NTLM authentication so that Windows domain users can log in as themselves

    That's it, really - configure read-only/read-write access via Active Directory group memberships or user lists built into SQL Monitor, and allow individual users to log in using their own AD credentials.

    142 votes
    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)
    completed  ·  Daniel Rothig responded

    SQL Monitor 5.0 lets you log in with your AD credentails. Admins can configure individuals or AD groups to have access to SQL Monitor, and have granular access control over which servers users can see.

  11. Add previous/next navigation to Alert Details

    On the Alert Details screen it would be extremely convenient to have the ability to navigate between issues within the same screen. Right now you have to either go back through all of the screens to get back to where you initially went to view the details of the alert, or use your browser's back button, which gives inconsistent behavior. This makes going through a high volume of alerts tedious and cumbersome.

    This could be handled by something as simple as a "previous/next" buttons on the Alert Details screen. Something akin to the "oldest/older/newer/newest" buttons on the Alert Inbox screen.

    41 votes
    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)
    completed  ·  Adam responded

    We have now implemented this suggestion in v3.1.

    During our usability testing we found that ‘newer/older’ was less ambiguous than ‘previous/next’. Filters now persist on the Alert inbox until they are manually cleared, so you can navigate away and always return to the filtered alerts.

    We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com. Thanks again for the suggestion and comments.

  12. add the ability to have multiple users

    It would be benefical to have an admin account that can allow config changes to be made and also a "guest" user which could review the data that was collected but not modifiy the settings.

    44 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  11 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)
  13. Skip warnings on Database Snapshot Backups

    I'm seeing warnings about backups not getting done on snapshots. Obviously it's not looking at the type.

    16 votes
    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)
  14. Add mirroring monitoring

    I may be wrong but I can't see that you have the capability for mirroring monitoring in the tool. This would make a more persuasive case for replacing Idera if this tool was included.

    38 votes
    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)
  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  22 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)
  16. Show prefered/active node on cluster

    When runnning a database instance on a cluster it would be helpful if you could see on which phusical machine (node) the database instance is active on. It would be very usefull if that information was shown on the global overview page.

    8 votes
    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)
    completed  ·  Daniel Rothig responded

    This can be seen on the Cluster overview page, in the instances grid – activeness and preferredness differ per FCI

  17. Support for regular expressions

    Most of the alarms need more granular support for excluding/including different things. Using regular expression is a good idea and should be extended further. For example you defenitly need to be able to filter out things from the alarm on the sql server errorlog. Without it's useless.

    74 votes
    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)
    completed  ·  Adam responded

    Thanks for this suggestion, and for the supporting comments.

    Several alerts now allow you to enter regular expressions to match text you want to ignore, to stop alerts being raised in certain situations.

    For example:
    - Deadlock (XE) alerts can be filtered by database, login name & resource (added in version 8.0.22 released November 13th 2018)
    - Blocking Process alert can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressions
    - Job Duration Unusual alerts can exclude jobs matching regular expressions
    - Long Running Query alerts can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressions

    We will mark this suggestion as completed, so that the votes can be returned while we continue to look at ways to make alerting more useful. Please make new suggestions for specific improvements you would like to see,…

  18. Add option for more detailed email alert

    It would be good if there were more detail levels of mail alerts.
    Example: I would like to see not only block process, but also which database and object; In case of failover, I would like to see both nodes failed and active ....

    31 votes
    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)
    completed  ·  Priya Sinha responded

    SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.

    Thanks,
    SQL Monitor Development Team

  19. Include Stored Procedure performance

    Include which stored procedures executed have high CPU, memory utilization, IO consumption. Also, include top wait types on Global Overview in addition to CPU and Memory

    43 votes
    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)
    completed  ·  Daniel Rothig responded

    The most performance-relevant stored procedures and ad-hoc queries can be inspected with the “Performance Diagnostics” feature on the Instance and Database Overview screens. This information is also replicated in the Performance section of the alert details pages

  20. Periodically or manually request "check disk size" for when SAN Drives are reconfigured on the fly

    We resized the log drive from 100GB to 170GB. SQL Monitor shows 100GB until the base monitor service is restarted.

    Periodically, i.e., once a day, re-check disk sizes.

    Perhaps on the configuration page, show a button to "re-evalute server base characteristics", which would include disk drive sizes.

    10 votes
    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)
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base