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.
186 results found
-
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 -
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
-
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.
-
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 -
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 -
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 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 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.
-
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.
-
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 -
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
-
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 -
Integrate SQL Monitor notifications with devices, ticketing systems and and other monitoring tools
CONTEXT: SQL Monitor is one of multiple tools I use to monitor my estate, such as SCOM, Tivoli, and OpenView. I would like to consoldate notifications from all of these tools
PROBLEM: SQL Monitor only sends human-readable email notifications, but other integration points like SNMP traps are not provided out of the box
EXAMPLE SOLUTIONS:
• Provide an SNMP demon against SQL Monitor's alerting data
• Make SQL Monitor send SNMP notifications out of the box
• Ability to send SMS or other push notifications
• Ability to "forward" an alert into a ticketing system127 votes -
Show prefered/active node on cluster
When runnning a database instance on a cluster it would be helpful if you could see on which phusical machine (node) the database instance is active on. It would be very usefull if that information was shown on the global overview page.
8 votesThis can be seen on the Cluster overview page, in the instances grid – activeness and preferredness differ per FCI
-
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,…
-
Add option for more detailed email alert
It would be good if there were more detail levels of mail alerts.
Example: I would like to see not only block process, but also which database and object; In case of failover, I would like to see both nodes failed and active ....31 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 -
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
-
Periodically or manually request "check disk size" for when SAN Drives are reconfigured on the fly
We resized the log drive from 100GB to 170GB. SQL Monitor shows 100GB until the base monitor service is restarted.
Periodically, i.e., once a day, re-check disk sizes.
Perhaps on the configuration page, show a button to "re-evalute server base characteristics", which would include disk drive sizes.
10 votesDisk capacity is re-evaluated regularly (every 10 minutes or so)
-
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
- Don't see your idea?