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.
182 results found
Create an Iphone app with a heatmap for the alerts. As well as an improved Analysis screen where you can select/combine/mix multiple metrics
Create an Iphone/android app with a heatmap for the alerts. As well as an improved Analysis screen where you can select/combine/mix multiple metrics31 votes
Closing because this is multiple suggestions: The analysis screen request has been completed in SQL Monitor 3.3 – as for the mobile site, if you favour this please vote for: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/3641809-provide-mobile-version-of-alert-monitoring-screen
Order databases alphabetically in the Analysis view
In the analysis tab, when you select the metrics and the server, where there is a database list, the list of databases is not ordered alphabetically. It would be much easier to find the database you want to look at if it was ordered - especially on servers with lots of databases.7 votes
..retry operations that fail during install/ initial connection to server. Such as at my server where DBCC TRACEON (1204,-1) failed. In that
..retry operations that fail during install/ initial connection to server. Such as at my server where DBCC TRACEON (1204,-1) failed. In that case, retrying would be good, to ensure that it is eventually turned on.1 vote
Regarding Custom Metrics - allow us to either have the "Description" inserted into the email or give us another text field for annotating.
We have solution documents in a help desk application. I would like to have my error message emailed with a suggestion that the recepient reference the solution document for steps in resolving the problem.4 votes
SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor. For custom alert, emails now include description.
SQL Monitor Development Team
Add more information to alert email
It would be nice to have more information sent into the alert email, instead of having to login into the monitor to check details. I am not sure if there is a way to do this already. If there isn't - this would be nice to have.
For e.g: This doesn't divulge which query. If the query was mentioned, it would help.
SQL Server: (local)
Machine: (Machine Name)
Alert type: Long-running query
Time raised: 8 Mar 2012 12:44 PM (UTC-05)
Time ended: 8 Mar 2012 12:50 PM (UTC-05)
View full alert detail147 votes
SQL Monitor V 3.3. has now released. This release contains improved subject lines and message bodies of alert emails to help you quickly understand problems before logging in to SQL Monitor.
SQL Monitor Development Team
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
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.
Allow drilldrown capability for different resource areas
It would be nice to be able to see which sql statements or db users were generating the most CPU usage, RAM usage, and Disk IO. This would help us quickly identify bottlenecks on the system.
CLR statistics would be nice to have too since we have found that it can account for locking issues in certain circumstances.5 votes
Resource utilisation per query can be seen in the top 10 queries view on the SQL Instance overview
When using "Back" browser function PLEASE put me back at the same place in the LONG list!
Although http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/2022999-add-previous-next-navigation-to-alert-details talks about previous/next, buried in it is the problem of wading through PAGES, AGAIN of stuff I've hunted through.
I'd like to add this separate request to deal with the simple issue of "put me back at the same place in the list as I was when I clicked an Alert to view".
I should not be forced to clear younger Alerts just so the Alert I'm on appears on page 1, either (not an elegant workaround).
We ran a series of usability sessions which included the new work we have completed adding previous/next (well, newer/older) and making filters persist, to understand how we should adapt this.
Now, when you work through a number of alerts using the newer/older navigation, clicking on the inbox will take you to the inbox at the point you would be – i.e. you will ‘emerge’ at that point. Hopefully this will solve the problem as you will not ‘be forced to clear younger alerts’.
We hope this solution works for you and we’d be interested to hear how you find the new features.
Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed on SQL Instance overview
Have ability to sort list of machines on the Analysis page and anywhere databases/machines are listed2 votes
Object lists are now consistently sorted alphabetically
Show the database name not just dbid in the Lock Details of a Deadlock alert
I've got to do the extra step of:
to figure out which database the deadlock is referring to... shouldn't have to do this.71 votes
Database name is now shown for 2005+ deadlock alerts following the v4 release.
Thanks again for the suggestion and votes.
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
This feature is already present in the SQL Monitor.
It would be grand if I could change the time format.. 12 hour clocks just don't sit right with me.
It would be grand if I could change the time format.. 12 hour clocks just don't sit right with me.35 votes
We have just released version 6.0.7 and this update means the clock can now be displayed in either 12 or 24 hour format – this can be toggled at Configuration > Display settings.
Thanks for your patience.
SQL Monitor Development Team
add the ability to specify a default filter. I'm getting tired of having to re-select my custom filter each time I click on the Alerts tab.
When working through a huge list of alerts, if I don't remember to click on the "back" button I am forced to re-select my custom filter from the Filter dropdown list.
If would save some time if a custom filter could be specified as the default Alerts filter.4 votes
In v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can navigate away and always return to the filtered alerts without having to reselect the filter from the dropdown list.
We hope this fixes the root of the problem that your workaround was a suggestion for. We’re interested to hear your feedback on this feature so please let us know at email@example.com. Thanks again for the suggestion and comments.
Ability set working hour for analysis graph
ability set working to compare last x day for only working hour2 votes
You can already do that – just specify what your working hours are in the time selector boxes
Invistigate v3.0 EAP Base Service CPU utilization
I first installed v2.3 and then switched to v3.0 EAP. It seems that the base service is maxing out CPU utilization which was not the case with 2.3.1 vote
Marking this as complete as it is a bug rather than enhancement/ feature request. Any bug related to EAP can be reported at firstname.lastname@example.org.
Preserve advanced filter settings when page size is changed
When viewing alerts and changing page size, a predefined filter setting is preserved, but any other advanced settings appear to be reset.4 votes
In v3.1 the filters now persist on the Alert inbox until they are manually cleared, so you can change the page size or navigate away and always return to the filtered alerts without having to reselect the filter.
We’re interested to hear your feedback on this feature so please let us know at email@example.com.
Thanks again for the suggestion and comments.
Traceflag 1222 for deadlocks
Use traceflag 1222 for deadlocks when monitoring SQL 2005+, and keep 1204 just for SQL 2000 instances. 1222 gives so much more information and doesn't cut off the SQL text.48 votes
We are pleased to annouce that this feature is now implemented as part of v4.0 release. Please check release notes for more details.
Enable and track wait stats
I would like to see an overview of wait statistics along with historical tracking of those waits. I currently have queries that would show the total wait time, but other tools I have used will provide a current snapshot of these waits as well as store them historically so that I can monitor changes.72 votes
We are excited to annouce that SQL Monitor v4.0 has been released. This release contains Performance diagnostics features which let you analyze the waits and queries affecting SQL Server performance on the Instance overview and Database overview pages. Check out the release notes for more details.
SQL Monitor Development Team
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
Report average page life expectancy
The "page life expectancy" performance counter can be a good indicator of an impending performance problem. It's in the "Buffer Manager" performance object.
- Don't see your idea?