Suggestions
Welcome to the Redgate Monitor feature suggestions list. Tell us how we can improve Redgate Monitor by voting on these suggestions or by submitting your own ideas.
This is the easiest way to make an impact on Redgate 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 Redgate Monitor forum.
207 results found
-
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 votesIn 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 usability@red-gate.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 votesHello,
We are pleased to annouce that this feature is now implemented as part of v4.0 release. Please check release notes for more details.
Thanks,
Priya -
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 votesHi,
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.
Thanks,
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.
1 vote -
Ability to store a baseline
After attending SQL in the city and listening to Grant Fritchey talk about the need to create baselines (and demo sql monitor) a feature I would like is the ability to create a baseline over 24 hours and have it stored. This could be then added to the analysis page as a Versus. ie last hour vs baseline, last day vs baseline.
118 votesWith SQL Monitor v.3.5 introducing a powerful baselining feature, we consider this suggestion as completed.
One thing our implementation doesn’t do (though it was mentioned in a couple of comments) is to be able to “freeze” a data range so as to retain a static baseline. We’ve created a suggestion for this additional functionality – so if you are interested in that aspect please vote on the following suggestion: http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/11122092-select-and-store-a-static-baseline-for-future-refe
Thanks
Daniel -
add LDAP/NTLM authentication so that Windows domain users can log in as themselves
That's it, really - configure read-only/read-write access via Active Directory group memberships or user lists built into SQL Monitor, and allow individual users to log in using their own AD credentials.
142 votesSQL Monitor 5.0 lets you log in with your AD credentails. Admins can configure individuals or AD groups to have access to SQL Monitor, and have granular access control over which servers users can see.
-
Change colour of chart line
When viewing a single metric chart in 'Analysis', the line is a yellow-golden colour, which I find horrible (just my opinion) and hard to focus on - can this be configurable?
1 voteThis was completed in 3.0 – apologies for not updating sooner.
We changed the colour palette and improved it. We have still had to use yellow due to the number of dbs it’s possible to display, but it will be used last and is more of a mustard/orange yellow now. We’ve also deepened other colours so the Analysis page should be easier to view.
We hope this is fixes the problem – thanks for the suggestion – and we welcome any feedback.
-
Allow filter on Global Overview
E.g. exclude 'Ended' (but not yet cleared) alerts. (Gives an overview of the current state)
8 votesWe believe improvements to the dashboard in 5.2 make this no longer valid. Please open a new suggestion if you would like to see further improvements.
-
Email Alerts subject info
Change the subject to the email alert, remove the SQL monitor ID number as taking up space without adding value, making it more difficult to gather the neccesary info from the subject line for job failure etc when viewing email through a portable device iPhone etc.
6 votesSQL 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.
Thanks,
SQL Monitor Development Team -
add the ability to have multiple users
It would be benefical to have an admin account that can allow config changes to be made and also a "guest" user which could review the data that was collected but not modifiy the settings.
44 votes -
Add previous/next navigation to Alert Details
On the Alert Details screen it would be extremely convenient to have the ability to navigate between issues within the same screen. Right now you have to either go back through all of the screens to get back to where you initially went to view the details of the alert, or use your browser's back button, which gives inconsistent behavior. This makes going through a high volume of alerts tedious and cumbersome.
This could be handled by something as simple as a "previous/next" buttons on the Alert Details screen. Something akin to the "oldest/older/newer/newest" buttons on the Alert Inbox screen.
…
41 votesWe have now implemented this suggestion in v3.1.
During our usability testing we found that ‘newer/older’ was less ambiguous than ‘previous/next’. Filters now persist on the Alert inbox until they are manually cleared, so you can navigate away and always return to the filtered alerts.
We’re interested to hear your feedback on this feature so please let us know at usability@red-gate.com. Thanks again for the suggestion and comments.
-
Put SQL statements from "top 10" in a textarea box
I'd like to see the SQL statements in the "Top 10 expensive queries" inside a textarea box so it's easy to copy and paste out of it.... The current layout of putting the SQL in a div makes it difficult to get the SQL out of there to paste into Management Studio to examine
3 votesthey are in a textarea: Doubleclick to copy
-
Add an alert to monitor failed logins.
The sql logs show failed logins, could we have an alert for this?
15 votesHello,
We are happy to announce that ‘Failed SQL Server logins’ metric is now available. Please install it from http://sqlmonitormetrics.red-gate.com/failed-sql-server-logins/
Thanks,
SQL Monitor development team -
Add mirroring monitoring
I may be wrong but I can't see that you have the capability for mirroring monitoring in the tool. This would make a more persuasive case for replacing Idera if this tool was included.
38 votesHello,
We are excited to announce that mirroring metrics from Grant Fritchey are now available to install. Please install it from http://sqlmonitormetrics.red-gate.com/tag/mirroring/. These metrics are also described in detail in Grant Fritchey’s article on Simple Talk https://www.simple-talk.com/sql/sql-tools/custom-metrics-for-monitoring-database-mirroring/.
Thanks,
SQL Monitor development team -
Support for regular expressions
Most of the alarms need more granular support for excluding/including different things. Using regular expression is a good idea and should be extended further. For example you defenitly need to be able to filter out things from the alarm on the sql server errorlog. Without it's useless.
74 votesThanks for this suggestion, and for the supporting comments.
Several alerts now allow you to enter regular expressions to match text you want to ignore, to stop alerts being raised in certain situations.
For example:
- Deadlock (XE) alerts can be filtered by database, login name & resource (added in version 8.0.22 released November 13th 2018)
- Blocking Process alert can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressions
- Job Duration Unusual alerts can exclude jobs matching regular expressions
- Long Running Query alerts can be filtered to exclude queries with a SQL process names, SQL commands or objects match regular expressionsWe will mark this suggestion as completed, so that the votes can be returned while we continue to look at ways to make alerting more useful. Please make new suggestions for specific improvements you would like to see,…
-
Skip warnings on Database Snapshot Backups
I'm seeing warnings about backups not getting done on snapshots. Obviously it's not looking at the type.
16 votesFixed in SQL Monitor 5.0.2
-
Have ability to sort list of databases on SQL Instance overview
It might be helpful to have the ability to sort these by name, esp. when this list happens to be quite long. It seems like under the current design they are sorted by database ID.
I have to scroll past 50+ db's to see the remaining info on the UI - can this be improved? Collapsing the list or adding some filtering, e.g. filter to limit to x# which is then changeable by page index, or filter by other than OK status
43 votesThis list is sortable as of SQL Monitor 4.0 (it is also truncated by default, making it easier to scroll past it)
-
Select multiple counters for Analysis
It would be helpful to see and compare multiple counters for an object in the Analysis tab.
41 votesSQL Monitor v 3.3 has been released. This release contains ability to display multiple metrics in the same Analysis graph to identify correlations and unusual patterns of behavior more easily.
Thanks
SQL Monitor Development Team -
Include Stored Procedure performance
Include which stored procedures executed have high CPU, memory utilization, IO consumption. Also, include top wait types on Global Overview in addition to CPU and Memory
43 votesThe most performance-relevant stored procedures and ad-hoc queries can be inspected with the “Performance Diagnostics” feature on the Instance and Database Overview screens. This information is also replicated in the Performance section of the alert details pages
- Don't see your idea?