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.


  1. View stats for queries across databases and / or servers

    Given that one has multiple similar databases, recieving the same queries, having same indexes and so forth. Currently one are able to view top-queries on server and database level, but what would be very valuable is to see the same information across databases on a server and across servers where one would then match the query on a content of the query itself. Then one could pinpoint globally what queries that has high io / cpu / ... even tough they on a individual db-level is not "high"

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  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 smaller timeframes on the server overview page.

    Currently if you dive into the overview page of a certain server the default timeframe is 24 hours, you can narrow this into 12,6,3 and 1 hour.

    I would like to have the opportunity to narrow it down into minutes.like a custom time frame. This helps to do a more clean investigation.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Monitor Partitioned Tables in SQL Server

    Be able to monitor and alert on sql paritioned tables. Such as if a retention of a table is 30 days and it retains data greater then 30 days, I should be able to get an alert. Be able to get alert on things like if older partitions are not merging or new partitions are not splitting or data being stuck in one partition...etc Able to see growth and changes in the partitions...

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  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. Testing the Availability Group listener(s)

    If an Availability Group listener is not working for any reason (like no DNS resolution), but the ressource is still up in the cluster, SQL Monitor will not raise any alert.

    Could you add a specific test for SQL monitor to test the connection using the availability group listener(s) and raise an alert if not successful?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Remember the Filter Layout

    On the Alert Inbox it would be nice to be able to re-arrange the filters and for the options to be remembered no matter where I login.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Exclude serverless databases from monitoring

    Need the ability to exclude serverless databases from scanning. The purpose of using serverless is to suspend when not in use, drastically reducing costs. Currently these databases are "kept awake" by SQL Monitor and never go to sleep. This is a deal-breaker for use on some of our servers...

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  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. SQL Monitor to Authenticate Directly with Office 365, Exchange Online

    Hello, it would be great if SQL Monitor could authenticate directly with Office 365 rather than having to use an on-premises SMTP server. Exchange Online is probably the most widely used email service for business and the application is unable to successfully authenticate with it. Thanks.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. alert when database was created / dropped

    It would be nice to have a build in alert when someone (e.g. a vendor) created or dropped a database.

    Reasons:
    - you may want to delete old backup files (if dropped) or have to modify / delete some maintenances
    - you'll make a manual full backup of the new DB so that log-backups could be taken by your backup solution
    - maybe you have to add the new DB to monitoring (as DLM Dashboard), backups (and have to consinder its the disk space at the backup drive) or an Excel-Sheet with a list of your databases :-)

    Real-Live-Example:
    I…

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Add Query Impact metrics into analysis graphs

    Add the ability to report on Query Impact metric in the analysis section to monitor trends.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. azure overview

    Azure SQL databases display differently than SQL server databases on the overview page, which makes them difficult to see. And even with the Azure SQL databases, there are further differences if the databases are members of elastic pools or not.

    Please change the Overview Page to either a) show them more consistently, since there's no other indication of what's different.
    or b) rearchitect the way Azure SQL DBs are displayed on the overview page so it's clear they are Azure SQL and that would also give you the ability to show them whatever way makes the most sense for the…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. "Take Screenshot" Feature in Analysis Section

    I have the need very often to take screenshots for non-technical management slideshows.

    Could you add a button in the analysis panel to take a screenshot of the analysis timeline?

    I would like to obtain something like this (with a single click)

    https://images4.imagebam.com/c4/e9/b5/MEC1R73_o.png

    Thank you

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. can use proxy

    We have internet access through proxy. I need SQL Monitor to work through this. for example download latest update

    2 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  ·  Flag idea as inappropriate…  ·  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. Have option to keep the base instance name in display for availability groups

    We have the option to choose between Windows cluster name and FCI network name for FCI. However, in an Availability Group scenario, every instance is being show by the cluster name first, which is obviously the same for all of them. This makes it difficult to identify the correct one when you need to look at a specific instance. Would like to add this as a configuration option so that clustered AG servers we can also choose whether to use cluster name or instance name as display

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  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. To show top server Process memory usage

    Under the "Processes", it would that we can sort the top memory usage as well. There are times we got alert that the server memory usage is high and we need to know what other OS processes is utilizing the server memory other than SQL.

    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  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Have more retention periods for the data retention settings.

    Right now on the data retention settings screen, there is only a drop down with a static list of ranges to keep data. It would be useful if these could be more granular, like being able to set both the number and interval (month,day,year). At a minimum, it would be nice if there were options between 1 year and indefinitely.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  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. Update the password of the account with powershell module

    I do not want to use the base monitoring account, to monitor the different databases. So I need to use a separate account for that. In order to regularly be able to rotate the password of this account, I would need the PowerShell module be updated with a function to update the password.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  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. Add alias with powershell module

    We install our sql server automatically via powershell, so we also add them there to the monitoring. We would like to safe us work, by giving the server a custom alias while adding to the monitoring as it can be done through the website.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  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. For the "Job failing" alert, add the ability to exclude job categories

    The "Job failing" alert currently has the ability to exclude jobs based on job name and owner. It would be very useful to also have the ability to exclude jobs based on the Agent Job Category.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Data Export

    Export the top querys list with detail as excel file or can be mail to another person.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Increase SQL Monitor email Alerts to larger than 400 KB

    We have some alerts for important servers that require you to login to SQL Monitor to see the full details because they exceed 400 KB. The alert currently reads:

    "Details
    Details omitted because they exceeded 400KB. Please log into SQL Monitor to view them.
    View full alert details
    Configure alert"

    Please increase this value so that we can see the full alert details within an email instead of having to login to SQL Monitor to see them.

    Thank-you!

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3 4 5 31 32
  • Don't see your idea?

Suggestions

Categories

Feedback and Knowledge Base