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.
683 results found
-
Unlicensed Databases
If a license is removed for a database, a banner at the top of the page shows up saying, "You have unlicensed servers. Unlicensed servers will not be monitored and will not raise alerts. Manage licenses | Manage monitored servers". And, on the "Configuration > Monitored servers" page the databases show with a red x, as Unlicensed, and a Manage licenses link.
It is good that licenses can be removed for individual databases, however it would be better to be able to remove the databases once they are unlicensed, so that we don't have to have the banner and the…
1 vote -
Force re-check of index fragmentation alert
The index fragmentation alert is checked only once per week, because of the load is causes on the system. I am fine with that.
However, I would like to have the option to force an immediate re-check for a specific database - for instance by adding a "re-check" button to the alert window.SCENARIO: The index fragmentation check runs on Saturday and triggers an alert on one database. On Monday I check the alert but I know that the weekly index defragmentation job runs on Sunday, so it is likely that the problem is already fixed. But I like to…
11 votes -
Click to open analysis from alert window
For some alerts, I like to see not only what happened before, but also what happened since. Some examples are disk space, or database file usage. The latter for example has a nice graph of the file usage up to the moment the alert triggered. But when I look at it the next day in the office, I also want to see what happened since - did the file continue to grow, has it been stable since, or was this a peak and is less space used now?
Currently that means going to the Analysis tab, selecting the correct server…4 votes -
Clone custom metrics for copying
When I have a very simular custom metric, I want create. I have to copy and paste . Can we have a clone custom metric feature?
7 votes -
A column with end of extended support in Estate
In addition to the column with end of mainstream support it would be nice to have a column with end of extended support in the Estate tab
13 votes -
Allow users to specify the time period in minutes for the top 10 expensive queries
I would like to specify that exact minutes on the slider for Top Queries. Currently you can only do a 15-minute change. But I would like to be able to do that down to a minute range. Sometimes we make a change and I don't want to wait 15 minutes to filter out the previous queries.
2 votes -
Add a summary tile for deployments to a database
I'd like to see a summary tile for deployments to a database by SQL Compare and SQL Change Automation.
Also it would be good if alerts can be created for these events.3 votes -
Report from Primary server in HA Group, even after failover
In a High Availability Group we have reports configured against the Primary server. When there is a failover, the reports should still be against Primary but are no longer, so need to be edited. Ideally, we should have reports that are always running against Primary, even when it switches to another server.
4 votes -
Add 'Details' column to the Alert inbox between Object and Unread column
Add 'Details' column to the Alert inbox between 'Object' and 'Unread' columns
6 votes -
Show when a Windows/SQL patch was applied
The current SQL Estate Monitor will show activity for a specific server and has the ability to show when code for example was deployed. I mentioned at the recent SQL in the City in London that it would be good to see any kind of patching that had been applied to that server as well. Get quick eyes on anomalies after a windows update or SQL patch.
2 votes -
Search for SPID for specific Date and Time
I would be a good idea to have a functionality in SQL Monitor to search for SPID for specific Date and time. This will help us to review what query run by who on given date and time.
1 vote -
Alerts for high virtual log file count
Alert on high transaction log virtual log file count. Also being able to configure the thresholds to be alerted on.
4 votes -
rss
RSS Feed, can it be exposed so logon to SQL monitor isn't needed
1 vote -
Notification
Generate Notification Per Alert (optional) and Show in windows
when Browser is Close.
And then Send Text Message To User Mobile Number1 vote -
Add option to make Reports public - i.e. available without having to log in
..so that i can add a publicly (internally..) available all-in-one dashboard view to my NOC TV screens, presenting all relevant information at a glance!
27 votes -
Select Database
Select Database
When Selected Instance And Add For Monitoring . I can not Selected/Unselected Database For Monitoring.
If possible, add this feature.5 votes -
Show login or user in the Top 10 Queries
Include login or user id information in the Top 10 Queries. This could help identify if a user is running an ad-hoc query.
42 votes -
Change unable to connect error messages to include DNS issues
Added a server via IP address as it's in a remote DC, test ran fine. After clicking Add to monitor the server, SQL Monitor resolved the IP to the cluster name, and attempted to add the 2 cluster servers via name (which is great, much easier to recognise servers via name than remember the IP), however SQL Monitor failed to connect, with WMI errors, RPC Server unavailable etc.
These errors were misleading, as the real reason it wouldn't connect is that the server couldn't resolve the DNS names. Adding them to Hosts file sorted it straight away.
Connecting should attempt…3 votes -
provide a scale on the analysis graph when monitoring disk reads and writes
provide a scale on the analysis graph when monitoring disk reads and writes
1 vote -
on the overview, monitored instances be able to choose which groups to show
It is possible to choose one or all groups on the monitored instances overview. I would like to be able to select more than one group to show or deselect some groups that I do not want to see.
3 votes
- Don't see your idea?