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.


198 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. create a function to allow clearing of all alerts on a given server, instance, database.

    Currently i can only find a way to clear 100 alerts at a time, or to purge information from the SQL monitor. It would a nice easy feature to be able to clear all alerts in one go.

    3 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)
  3. Custom Metric Order

    Either allow an order to be defined for custom metrics on the analysis tab or at least order them alphabetically rather than in the order created.

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

    We’ve alphabetically ordered the custom metrics on the Analysis tab and this will go in the next release which we hope to have available later next month.

    Thanks again for the suggestion.

  4. Alert if any data collection of metrics values stops unexpectedly

    For some reason our data collection stops every other week for certain metrics. Restarting the SQLMonitor-service will make the service resume collecting again.
    As it is now we have to inspect each metric manually to identify problems.
    I would like an alert if any data collection stops unexpectedly.

    3 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)
  5. Day of week is not considered in Analysis Graph when comparing this mont with last month

    When comparing this month's data with last month's data, the 1st of this month is compared with last month's 1st.
    This might not be relevant if, for example, the first of the current month was a Wednesday and the 1st of last month was a Saturday.

    When comparing this week with last week, this Monday is Always compared with last Monday asf.

    So, it would be nice to have a new option where the day of week is considered.

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

    SQL Monitor v3.4 is now released.

    The new features include:

    • Time ranges and comparison on the Analysis graph are fully customisable, making it easier to identify unusual patterns of behaviour.
    • There are now more ways to manipulate the Analysis graph, including clicking and dragging to change the time frame, and zooming in and out with the mouse wheel.

    Thanks,
    SQL Monitor Developement Team.

  6. Overlap

    To analyse a trend over a period of say 30 days using one continuous line graph is difficult. If we could see a line for day 1, overlapped with day2, day 3 etc over the same 24 hour period then its easier to see trends and patterns e.g. processing time increases at 1pm everyday

    Regards

    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)
  7. Raise Alert level based on time

    Currently all alert levels are based on the numbers allocated and the alert is simply triggered at that level,

    Some of the values I'm tracking sit at 0 quite often, the problem is less the number but the length of time that it remains at that number

    So after 5 collections i would like to raise a low alert, after 10 collections a medium and after 20 a high alert

    Thanks for your time and concideration

    Ste

    3 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)
  8. Bring back the ability to list fragments of T-SQL to reduce Blocking Process alerts, please

    By FAR the largest number of abject NUISANCE Blocking Process alerts I get across 17 servers is due to a simple "How is fragmentation going?" query from a 3rd party product (Idera Defrag Manager).

    Looks like this:

    use [DBName] declare @indexId int declare @dbId int declare @tblId int declare @partitionId int set @partitionId = 0 select @dbId = ISNULL(DBID(),-1) if @dbId=-1 RAISERROR( N'Database does not exist or permission denied: %s', 16, 1, '[DBName]' ) else begin select @tblId = ISNULL(OBJECTID('[DBName].[dbo].[TableName]') ,-1) if @tblId=-1 RAISERROR( N'Table does not exist or permission denied: %s', 16, 1, '[DBName].[dbo].[TableName]' ) else begin…

    3 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

    Version 6.0.16 has now been released and this includes the ability to add regular expression filters to blocking process alerts. We hope this completes your suggestion.

    Thanks, SQL Monitor Team

  9. Push 5.2 Alias down to Analysis and beyond

    The write-up about the 5.2 Alias feature waxes almost lyrical about how much we would like it...

    Until you open the Analysis page and see the old names - in my case unintelligible I.P. addresses. Sad, very sad...

    Please make Aliases utterly pervasive, as in Analysis, Configuration => Monitored Servers (I.P. list), emails (just to make sure they're not overlooked).

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

    I’m closing this suggestion because the server aliases were fixed in v5.2.2.

    However, there is currently no way to alias cluster/machine names, so if this is important, please do raise this as a suggestion as we could look to address that if there is demand

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

  11. SQL Monitor 5.2.5 upgrade dashboard server/SQL Server memory

    Upon upgrading from 5,1 to 5.2.5 the new Global Dashboard no longer shows machine memory vs. memory being consumed by SQL Server. Why was this removed? This can be critical to see if SQL Server or any other process is using up all of the servers memory.

    3 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. Apologies for not closing this sooner as it was completed a long time ago; we did agree that we should show machine memory vs. SQL Server memory and this is shown on the Server Overview memory chart.

    Thanks,
    SQL Monitor Development Team

  12. Please remove the 20 character size limitation from the Alias feature

    Given that actual server named instances can be longer than 20 characters (even if they are truncated on the display), it makes no sense to limit an alias to 20 characters. Please significantly extend this limitation.

    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  ·  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)
  13. Add a "Check for updates" link in the About section

    Alternative for when you've clicked away the "new version available" notification

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

    Hi,

    We have now added check for updates to the About section in version 7.1.16.

    Thanks for the suggestion. I’ll mark this as completed now, but do let us know if you feel it should be reopened.

    Thanks
    Adam
    SQL Monitor Development Team

  14. Database File Usage Alert - Autogrowth

    Database File Usage Alert : Please consider autogrowth! So far, this alert is of no help.

    3 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

    SQL Monitor v7.1.18 added an option to disable database file usage alerts when autogrowth is enabled. The setting can be found on the configuration screen for the database file usage alert.

    Thanks for helping us improve this feature with your suggestion.

    SQL Monitor Development Team

  15. 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)
    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)
  16. Alerting on Autogrowth Events

    Alerting on Autogrowth Events, some environments set the file size of their databases and would like to be alerted if autogrowth occurs since that indicates abnormal behavior

    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)
  17. reports timespan options

    Please add 14days as the timespan in the dropdown for the reports

    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)
  18. Have the ability to pin the left sidebar in the overview screen

    It'd be great if we could pin the sidebar on the left-hand side of the screen on the overview section when looking at a particular server. As I'm looking over metrics I oven find myself hovering over that section then waiting for it to expand and collapse again. An example concept implementation that I think would work well is similar to how Microsoft implements basically that same functionality in their office suite (in particular off hand outlook is a great example). Really just being able to pin it in place I think would satisfy the entire issue for me as…

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

    The sidebar is now either open or closed (it will no longer open on mouseover).

  19. Comment multiple alerts at once

    I would like the ability to add the same comment to all of my selected alerts before clearing them in the Alert Inbox.

    3 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

    Hi,

    Thanks for this suggestion.

    Version 8.0.23 has now been released and includes the return of the ability to add comments to multiple alerts.

    This was initially removed while developing the ability to group alerts, and it’s taken us longer than expected to reintroduce – apologies for the inconvenience this caused.

    We hope this solves this suggestion. We’ll mark it as completed, but please do reply if you have any further feedback.

  20. Don't check Agent status for Express Edition

    Whenever I add a server to the monitoring that is Express Edition, I get alerted that the SQL Agent service is not running.
    Well d'uh. It's Express Edition. The Agent service cannot run on it.

    Instead of always giving me this alert and then having me go in and disable it for yet another server, why not change the logic to not raise this alert at all when the edition is detected as Express?

    3 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