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
-
AWS FSx drive status
In our company we are using AWS FSx drives for our SQL Server databases. The FSx drives are not real drives, they are more like a shared folder, I'm wondering if there is a way to add those drives on SQL Monitor so we can check disk space and get alerts. AWS has been adding more features for FSx drives to be used on SQL Servers. Right now the only way to monitor that is using AWS console or alerts, which are not very friendly and only available for some system administrators.
7 votes -
Permission granularity on server/cluster objects
It would be great to assign a set of users in a security group a read only or any other access to a particular cluster node instead of the full cluster. It is a managed environment with shared responsibilities, so it is essential to have this granularity in permission management.
12 votes -
Central configuration of child base monitors from the parent/central base monitor
Context: We have a base monitor at our office connected to one or multiple base monitors at our clients environment.
Problem: To configure the base monitor at our clients location, we need to connect to that base monitor. In order for us to reach that base monitor we have a to connect through multiple VPN's and steppingstones, which makes a simple click a time consuming action for us.
Desired solution: We want to be able to configure a child base monitor from our central base monitor at our office. For example adding a member tot a group or check on…
23 votesWe will soon be exploring how to make it easier to configure multiple base monitors.
-
Disk space alert
The disk space alert can be configured on Server-Level as a host machine alert, but the alert is fired for every Instance on that host.
As example, we have 5 instances on a sever, each instance has it's own drive, e.g.
instance1 on drive d:
instance2 on drive e:
instance3 on drive f:
etc.If one instance, e.g. instance2 on drive e: is filling up it disk, the alert is fired for all instances. We would like to see an alert only for the instance that is affected and not 5 alerts.
1 vote -
Fragmented Indexes
Would like to add row count and fill factor to the alert as depending on how many rows there are depends on whether a reaction is needed
Fragmented indexes:
Index Table name Fragmentation(%) No. of pages1 vote -
Add a process that automatically checks to see if a stand-alone SQL Instance has become an Always-On Availability Group
There is a stand-alone SQL Instance that is being successfully monitored by SQL Monitor.
The SQL Instance importance has increased and the SQL Instance becomes an Always-On Availability Group. This change is not detected by SQL Monitor.
The work around is to remove the SQL Instance from being monitored and re-add, the SQL Instance for monitoring so that the change is detected.
Add a process that automatically checks to see if a stand-alone SQL Instance has become an Always-On Availability Group or has been removed from a Availability group to become a stand-alone instance once again.
6 votes -
See job history beyond one month
Currently the Estate Job page only offers a view of a day, week or month, but sometimes we need to see trends beyond one month.
Is it possible to add a variable window? Or a fixed one of a year?3 votes -
Fix the column headers for the Top Queries when scrolling
On the Server Overview "Top Queries" section, it would be helpful if the header row of the table didn't scroll off the screen. I keep scrolling back up to work out if I'm looking at reads/writes/CPU Time/etc.
4 votes -
Dashboard view for multi-instance environment
We have multi-instance SQL Server on one VM.
Today on dashboard we have waits for instance, and we need processor usage for instance also.We would prefer to have on tile:
1. Waits for instance
2. Procesor for instance
3. Disk i/o for instanceWe should have also tile which grup all instances into machine. On machine tile we shoul have the same information as for instance but measuers would count machine indicators.
There would be also great if You would add new dashboard view for multi instance environment.
My proposal for view in atachment (I am not a professional…
6 votes -
Send alert notifications at the central/parent base monitor
Context: We have a base monitor at our office connected to one or multiple base monitors at our clients environment.
Problem: Not all client base monitors are connected to the internet or opening an extra network port is a hard thing to get done. This makes it harder to setup alert notifications from that base monitor.
Desired solution: Send notification from the parent/central base monitor. This way we only have to set up notification on one central base monitor instead of multiple and use various notification types.
15 votes -
Webhook notification for Cleared events
We use Webhook notication to push the alerts to our central ITSM tool. The status "Raised" creates an entry, the status "Ended" deletes the entry in the third-party tool.
We would also like to be able to use the status "Cleared" to delete entries. For this, a webhook notification would also have to be triggered when the status changes to "Cleared", which is not yet the case.
2 votes -
list, and get alerts from the SQL Monitor API.
Add possibility to list, and get alerts from the SQL Monitor API.
This so we more easily can share and distribute alerts to a users that shouldn't have access to SQL Monitor.
In my org we have a lot of developers, and a lot of different databases that are hosted on the same clusters, I want the possibility to send more direct alerts and messages to these users.
42 votes -
custom RPO time
Custom RPO time. Have the ability to adjust the RPO to its values, for example 5 or 10 min. Not only 15minutes.
3 votes -
Alerts and Notifications Export
Would love to be able to export all notifications with details into Excel or CSV. Very beneficial to create dashboards, metrics and KPI for all notifications.
1 vote -
Provide a tile for an Availability group on the main page
Should be able to see status of an availability group from the front page
7 votes -
Provide a report on queries with suggestions on improving performance
When viewing the top 10 queries, we can see suggestions on what may improve the performance for the specific query. Can this functionality be summarized in one report per database to suggest and what indexes could assist with improving performance.
I would like to see:
SQL Query, Query statistics, Query plan, Suggestion(s)(similar to top 10 but more extensive.)
Also provide searching capability to look for any suggestion that relates to a specific object.
This will assist DBAs to specifically drill into a specific issue query and provide instant suggestions on what can be done to improve performance for that…
5 votes -
see username and hostname in "top 50 queries" and "top 10 waits"
In SQL Monitor, I want to see username and hostname in "top 50 queries" and "top 10 waits"
Please add username and hostname in "top 50 queries" and "top 10 waits." These two columns will be useful to trouble shoot SQLs that are causing troubles
Thanks,1 vote -
Add Text Boxes/Areas to Reports
I have reports that I circulate from SQL Monitor. I have to edit these before I issue them to add additional information. E.g. Under the "Lock Waits/Sec" chart I have a description of what a "Lock Wait" is, what impact it has, what's an acceptable value, etc. I tried supplying a supplementary sheet with this info but the management team prefer it under each chart / metric.
1 vote -
Reduce the suggestions on how to fix queries when viewing Top 10 Queries
SQL Monitor pops up the text "x issues with this query". Addressing them could improve performance. It then lists some things that might have an impact (e.g. select * instead of listing just the columns that are required) but also lists other things that won't change performance (e.g. not specifying a schema name).
Can this list be reduced to just what is potentially performance related? Maybe have a 2nd field for best practices if that's considered improtant.
1 vote -
Remove "Configure alert" link from alert emails
This is a big issue for me because I send Job Failure alert emails to the development team, but I don't want different people configuring alerts on Redgate Monitor. Only DBA's can make changes to the monitoring configuration.
I don't think the "View full alert details" is necessary either. If developers need to see more information, they can look at the Job History.
4 votes
- Don't see your idea?