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.
663 results found
-
Being able to type the (graph) zoom range time
Sometimes is hard to quickly get to the time range we want to analyse.
It would be handy if we could have a "free text" time box to type:
Zoom range Start: 11:10
Zoom range End: 11:312 votes -
Make it possible to mark a query to be tracked from the database menu
On the "Top queries" within the database menu, we can only "View estimated plan" and "Copy query text".
It would be handy to have here the "Track query" option too.
Nowadays, if I find it here, I need to filter on the top and only then I can "Track query"
2 votes -
Add a scroll bar to the backup list (bottom within the specific database)
When we go to the "Databases" at the bottom and we expand a specific one we get the list of the backups that happened during the period we have filtered.
For a better experience, this list should have a vertical scroll bar it it it will show more than 5/10(?) entries.
Otherwise the general scroll bar will become smaller, the page height increase a lot and we need to scroll much more
2 votes -
Being able to set alerts based on existing KPIs (Analysis Graph) instead of create a new custom metric
If I want to create an alert based on some existing KPIs, I need to write the query and can't leverage the existing one.
Example:
I want to create an alert when the "Tempdb: Free bytes" is lower than X.
I can't use the existing "SQL Server metrics" that contain this KPI.
Instead, I need to create a new custom metric and build the query. (which in the end it will be exactly the same). Only after that I can create an alert.2 votes -
When "Totals" is selected, on mouse over still display average values for the metrics
When we change from "Avg. per execution" to "Totals" the row order can change.
With bigger numbers, it becomes harder to quickly know if the average is high or not to decide to take a further look.
Instead of need to "Track query" and then click back and forth with "Avg. per execution" / "Totals" having the average on the tooltip when "Totals" is selected will be helpful.
2 votes -
Who ran the query and what time
I would like to see in sql monitor who was the person that ran the query and what time the query was run.
6 votes -
Database Tags
It would be great if, in addition to Instance Tags, we could assign tags to individual Databases as well. This could help in various ways in trying to determine what the purpose is of the vast number of databases we need to monitor and manage.
7 votes -
Banner Messages for planned Downtimes
Hi!
We want to put Banners on Top Global Dashboard to inform Users, that we planning Downtimes on SQL Monitor.
SQL Monitor has build in banners for unlicensed Servers and stuff like that. Would it be possible to show User Messages that there will be a Downtime on SQL Monitor?2 votes -
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?
7 votes -
See Transaction Isolation Levels in Blocking Alerts
There are two methods I have been using to understand blocking situations on our servers:
The processes tab in the Blocking Process alert
The blocking processes section in the server overviewI can get a lot of information from both of these methods but I don't seem to be able to get the isolation levels of the blocking or blocked queries which would be helpful in understanding why the blocking situation has occurred.
Prior to using SQL monitor, we used the blocked process report to monitor blocking and these include the isolation levels. Unfortunately, I still have to resort to…
1 vote -
Limit user access on clusters
I would like to be able to grant specific AD users / groups access to specific instances on a cluster. Currently its only possible to grant access at the cluster level which gives more access than is necessary. This would be a supremely useful feature for me!
3 votes -
Environment specific Reports
As we have option to create different reports on SQL Monitor, We would like to have the option to create the reports as per environment (Dev,UAT,Prod) for Disk Space,Server Downtime etc. It will be more feasible if we can get a filter to create reports for the specific environment.
1 vote -
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Provide AAD authentication mode to connect to Azure SQL server apart from username and password authentication.
Because if Azure SQL is set to AAD authentication only for security reasons in any organization, username and password to add new Azure SQL server/DB under SQL Monitoring doesn't help.
32 votes -
Alert Type for Polybase Service
Standard Alert Type for monitoring of the Polybase service status analogous to the other services (Browser, IIS, Agent, Full-Text, etc. )
4 votes -
Superimpose the Disk I/O for VMWare Host on graph for Disk I/O
I'd like to get the Disk I/O for the VMWare Host superimposed on the graph just as I get CPU and Memory, it is very helpful to see the load on the host together with the load on the actual VM.
3 votes -
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.
8 votes -
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 -
report to show Job status completed or failed. last run time and next run time
report to show Job status completed or failed. last run time and next run time
1 vote -
Save alert email addresses
I monitor a large enterprise and forward hundreds of alerts using cut/paste. If recent addresses were retained, it would save a lot of time.
1 vote -
can use proxy
We have internet access through proxy. I need SQL Monitor to work through this. for example download latest update
2 votes
- Don't see your idea?